APPS.PAY_CA_RL2_AMEND_MAG dependencies on PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Line 312: from pay_ca_eoy_rl2_employee_info_v emp,

308: );
309:
310: hr_utility.set_location( 'pay_ca_rl2_amend_mag.range_cursor', 20);
311: p_sqlstr := 'select distinct to_number(emp.person_id)
312: from pay_ca_eoy_rl2_employee_info_v emp,
313: pay_ca_eoy_rl2_trans_info_v tran,
314: pay_assignment_actions paa_arch,
315: pay_payroll_actions ppa_arch,
316: pay_payroll_actions ppa_mag,

Line 1423: FROM pay_ca_eoy_rl2_employee_info_v emp,

1419: emp.rl2_box_o,
1420: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1421: nvl(emp.negative_balance_flag, 'N'),
1422: emp.person_id
1423: FROM pay_ca_eoy_rl2_employee_info_v emp,
1424: pay_ca_eoy_rl2_trans_info_v tran
1425: WHERE emp.assignment_action_id = p_asg_action_id
1426: AND emp.payroll_action_id = tran.payroll_action_id;
1427: /* Commented for bug 8888411

Line 3085: FROM pay_ca_eoy_rl2_employee_info_v emp,

3081: emp.rl2_box_o,
3082: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
3083: nvl(emp.negative_balance_flag, 'N'),
3084: emp.person_id
3085: FROM pay_ca_eoy_rl2_employee_info_v emp,
3086: pay_ca_eoy_rl2_trans_info_v tran
3087: WHERE emp.assignment_action_id = p_asg_action_id
3088: AND emp.assignment_id = p_assignment_id
3089: AND emp.payroll_action_id = tran.payroll_action_id;