SELECT
concatenated_segments
FROM
apps.gl_code_combinations_kfv
WHERE
code_combination_id IN (
SELECT DISTINCT
default_code_comb_id
FROM
apps.per_all_assignments_f
WHERE effective_end_date >= sysdate
AND
person_id IN (
SELECT
person_id
FROM
apps.per_all_people_f
WHERE
effective_end_date >= sysdate
and person_id LIKE '&person_id'
)
);
No comments:
Post a Comment