DBA Data[Home] [Help]

APPS.PAY_DK_TCR dependencies on HR_SOFT_CODING_KEYFLEX

Line 72: per_all_people_f pap, hr_soft_coding_keyflex scl where

68: IS
69: select pap.person_id, paa.assignment_id, pap.NATIONAL_IDENTIFIER, paa.assignment_number, to_char(pap.date_of_birth,'yyyymmdd') dob,
70: first_name||' '||middle_names||' '||last_name pname, pap.effective_start_date
71: from per_all_assignments_f paa,
72: per_all_people_f pap, hr_soft_coding_keyflex scl where
73: paa.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
74: and scl.segment1 = p_le_id
75: and paa.business_group_id = p_bg_id
76: and paa.PRIMARY_FLAG='Y'