DBA Data[Home] [Help]

APPS.PAY_CA_T4_CANCEL_MAG dependencies on PER_ASSIGNMENTS_F

Line 114: per_assignments_f paf

110: and paa.action_status = 'C'
111: and paa1.action_status = 'C'
112: and exists (select 1
113: from hr_assignment_set_amendments hasa,
114: per_assignments_f paf
115: where hasa.assignment_set_id = l_asg_set_id
116: and upper(hasa.include_or_exclude) = 'I'
117: and hasa.assignment_id = paf.assignment_id
118: and paf.person_id = paaf.person_id)