DBA Data[Home] [Help]

APPS.PAY_CA_T4A_CANCEL_MAG dependencies on PER_ASSIGNMENTS_F

Line 111: per_assignments_f paf

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