DBA Data[Home] [Help]

APPS.PAY_MX_SUBSIDY_EMP_PD_RPT dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 386: from hr_assignment_set_amendments hasa

382: AND paa_arch.action_status = 'C'
383: AND paa_arch.serial_number BETWEEN cp_start_person_id
384: AND cp_end_person_id
385: AND (gv_ass_set_id IS NULL OR (exists ( select 1 /* Selected Assignment Set */
386: from hr_assignment_set_amendments hasa
387: where hasa.assignment_set_id = gv_ass_set_id
388: and hasa.assignment_id = paa_arch.assignment_id
389: and upper(hasa.include_or_exclude) = 'I')))
390: ORDER BY paa_arch.serial_number,

Line 418: from hr_assignment_set_amendments hasa

414: AND paa_arch.serial_number = ppr.person_id
415: AND ppr.chunk_number = cp_chunk
416: AND ppr.payroll_action_id = cp_payroll_action_id
417: AND (gv_ass_set_id IS NULL OR (exists ( select 1 /* Selected Assignment Set */
418: from hr_assignment_set_amendments hasa
419: where hasa.assignment_set_id = gv_ass_set_id
420: and hasa.assignment_id = paa_arch.assignment_id
421: and upper(hasa.include_or_exclude) = 'I')))
422: ORDER BY paa_arch.serial_number,