APPS.PAY_CA_RL1_CAN_MAG dependencies on PER_ASSIGNMENTS_F

Line 524: per_assignments_f paf

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
528: and paf.person_id = paaf.person_id)

Line 1397: l_asg_id per_assignments_f.assignment_id%TYPE;

1393: ORDER BY pei_information7; /*Bug 13564765*/
1394:
1395: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1396: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1397: l_asg_id per_assignments_f.assignment_id%TYPE;
1398: l_date_earned DATE;
1399: l_province VARCHAR2(30);
1400: l_O_AutreRevenu VARCHAR2(1000);
1401: