DBA Data[Home] [Help]

APPS.PAY_HK_IR56_ARCHIVE dependencies on HR_SOFT_CODING_KEYFLEX

Line 448: hr_soft_coding_keyflex hsck,

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

Line 1382: hr_soft_coding_keyflex sck,

1378: Cursor Get_ManualExclusion(p_assignment_id per_all_assignments_f.assignment_id%TYPE)
1379: IS
1380: SELECT pap.employee_number
1381: FROM per_assignments_f a,
1382: hr_soft_coding_keyflex sck,
1383: per_people_f pap
1384: WHERE a.assignment_id = p_assignment_id
1385: AND a.soft_coding_keyflex_id = sck.soft_coding_keyflex_id
1386: AND pap.person_id = a.person_id