APPS.PAY_CA_T4A_REG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 356: from hr_assignment_set_amendments hasa

352: paf.effective_end_date >= l_year_start and
353: paf.assignment_id = paa.assignment_id and
354: paa.payroll_action_id = p_arch_pactid and
355: exists ( select 1 /* Selected Assignment Set */
356: from hr_assignment_set_amendments hasa
357: where hasa.assignment_set_id = l_asg_set_id
358: and hasa.assignment_id = paf.assignment_id
359: and upper(hasa.include_or_exclude) = 'I');
360:

Line 390: from hr_assignment_set_amendments hasa

386: paf.effective_end_date >= l_year_start and
387: paf.assignment_id = paa.assignment_id and
388: paa.payroll_action_id = p_arch_pactid and
389: exists ( select 1 /* Selected Assignment Set */
390: from hr_assignment_set_amendments hasa
391: where hasa.assignment_set_id = l_asg_set_id
392: and hasa.assignment_id = paf.assignment_id
393: and upper(hasa.include_or_exclude) = 'I');
394:

Line 423: from hr_assignment_set_amendments hasa

419: paf.effective_end_date >= l_year_start and
420: paf.assignment_id = paa.assignment_id and
421: paa.payroll_action_id = p_arch_pactid and
422: exists ( select 1 /* Selected Assignment Set */
423: from hr_assignment_set_amendments hasa
424: where hasa.assignment_set_id = l_asg_set_id
425: and hasa.assignment_id = paf.assignment_id
426: and upper(hasa.include_or_exclude) = 'I')
427: and pds.actual_termination_date is not null

Line 460: from hr_assignment_set_amendments hasa

456: paf.effective_end_date >= l_year_start and
457: paf.assignment_id = paa.assignment_id and
458: paa.payroll_action_id = p_arch_pactid and
459: exists ( select 1 /* Selected Assignment Set */
460: from hr_assignment_set_amendments hasa
461: where hasa.assignment_set_id = l_asg_set_id
462: and hasa.assignment_id = paf.assignment_id
463: and upper(hasa.include_or_exclude) = 'I')
464: and pds.actual_termination_date is not null