DBA Data[Home] [Help]

APPS.PAY_CA_RL1_CAN_MAG dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 523: from hr_assignment_set_amendments hasa,

519: and paa1.assignment_action_id = int.locked_action_id
520: and ppa2.payroll_action_id = paa1.payroll_action_id
521: and ppa2.action_status = 'C'
522: and exists (select 1
523: from hr_assignment_set_amendments hasa,
524: per_assignments_f paf
525: where hasa.assignment_set_id = l_asg_set_id
526: and upper(hasa.include_or_exclude) = 'I'
527: and hasa.assignment_id = paf.assignment_id