APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_ACTION_INFORMATION

Line 498: from pay_action_information

494: order by effective_end_date desc;
495:
496: CURSOR c_get_prov_amend_flag(cp_asg_act_id number) IS
497: select action_information2
498: from pay_action_information
499: where action_context_id = cp_asg_act_id
500: and action_information_category = 'CAEOY RL2 EMPLOYEE INFO2'
501: and action_context_type = 'AAP'
502: and jurisdiction_code = 'QC';

Line 1373: pay_action_information pact

1369: pay_assignment_actions paa,
1370: pay_payroll_actions ppa,
1371: per_all_people_f ppf,
1372: per_all_assignments_f paf,
1373: pay_action_information pact
1374: WHERE paa.assignment_action_id = pai.locking_action_id
1375: AND paa.assignment_action_id = p_mag_asg_action_id
1376: AND paf.assignment_id = paa.assignment_id
1377: AND ppf.person_id = paf.person_id