APPS.PAY_CA_RL2_AMEND_MAG dependencies on PER_ASSIGNMENTS_F

Line 454: from per_assignments_f paf

450: and ppa.effective_date = cp_effective_date
451: and ppa.business_group_id = cp_business_group_id
452: and ppa.report_type IN ('CAEOY_RL2_AMEND_PP','RL2_XML_MAG','RL2_AMEND_MAG')
453: and exists (select 1
454: from per_assignments_f paf
455: where paf.assignment_id = paa.assignment_id
456: and paf.effective_start_date <= cp_effective_date
457: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
458: AND not exists

Line 1498: l_asg_id per_assignments_f.assignment_id%TYPE;

1494: l_negative_balance_flag varchar2(240);
1495:
1496: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1497: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1498: l_asg_id per_assignments_f.assignment_id%TYPE;
1499: l_date_earned DATE;
1500: l_province VARCHAR2(30);
1501:
1502: TYPE employee_info IS TABLE OF VARCHAR2(150) INDEX BY BINARY_INTEGER;