APPS.PAY_HK_IR56_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 450: hr_soft_coding_keyflex hsck,

446: per_contact_relationships pcr,
447: per_addresses pad,
448: per_assignment_extra_info paei,
449: per_periods_of_service pps,
450: hr_soft_coding_keyflex hsck,
451: hr_lookups hrl
452: WHERE paaf.person_id = papf.person_id
453: AND TO_DATE('31-03-'|| c_reporting_year, 'DD-MM-YYYY')
454: BETWEEN paaf.effective_start_date and paaf.effective_end_date

Line 1451: hr_soft_coding_keyflex sck,

1447: Cursor Get_ManualExclusion(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1448: IS
1449: SELECT pap.employee_number
1450: FROM per_assignments_f a,
1451: hr_soft_coding_keyflex sck,
1452: per_people_f pap
1453: WHERE a.assignment_id = p_assignment_id
1454: AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1455: AND pap.person_id = a.person_id