APPS.PAY_CA_RL1_AMEND_MAG dependencies on PER_ASSIGNMENTS_F

Line 527: per_assignments_f paf

523: pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
524: ppa.legislative_parameters)
525: from pay_payroll_actions ppa,
526: pay_assignment_actions paa,
527: per_assignments_f paf
528: where (paa.serial_number = to_char(cp_person_id) or paf.person_id = cp_person_id)
529: and paa.assignment_id = paf.assignment_id
530: /* and pay_ca_eoy_rl1_amend_reg.get_parameter('PRE_ORGANIZATION_ID',
531: ppa.legislative_parameters) =

Line 540: from per_assignments_f paf

536: and ppa.effective_date = cp_effective_date
537: and ppa.business_group_id = cp_business_group_id
538: and ppa.report_type IN ('CAEOY_RL1_AMEND_PP','RL1_XML_MAG','RL1_AMEND_MAG')
539: and exists (select 1
540: from per_assignments_f paf
541: where paf.assignment_id = paa.assignment_id
542: and paf.effective_start_date <= cp_effective_date
543: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
544: AND not exists

Line 1464: l_asg_id per_assignments_f.assignment_id%TYPE;

1460:
1461: l_original_slpno VARCHAR2(150);
1462: l_mag_asg_action_id pay_assignment_actions.assignment_action_id%TYPE;
1463: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1464: l_asg_id per_assignments_f.assignment_id%TYPE;
1465: l_date_earned DATE;
1466: l_province VARCHAR2(30);
1467: l_O_AutreRevenu VARCHAR2(1000);
1468: