APPS.PAY_CA_RL2_MAG dependencies on PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Line 228: from pay_ca_eoy_rl2_employee_info_v emp,

224:
225: hr_utility.set_location( 'pay_ca_rl2_mag.range_cursor', 20);
226:
227: p_sqlstr := 'select distinct to_number(emp.person_id)
228: from pay_ca_eoy_rl2_employee_info_v emp,
229: pay_ca_eoy_rl2_trans_info_v tran,
230: pay_assignment_actions paa_arch,
231: pay_payroll_actions ppa_arch,
232: pay_payroll_actions ppa_mag,

Line 1266: FROM pay_ca_eoy_rl2_employee_info_v emp,

1262: emp.rl2_box_o,
1263: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1264: nvl(emp.negative_balance_flag, 'N'),
1265: emp.person_id
1266: FROM pay_ca_eoy_rl2_employee_info_v emp,
1267: pay_ca_eoy_rl2_trans_info_v tran
1268: WHERE emp.assignment_action_id = p_asg_action_id
1269: AND emp.payroll_action_id = tran.payroll_action_id
1270: AND nvl(emp.rl2_source_of_income,1) not in --6525968

Line 3511: FROM pay_ca_eoy_rl2_employee_info_v emp,

3507: emp.rl2_box_o,
3508: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
3509: nvl(emp.negative_balance_flag, 'N'),
3510: emp.person_id
3511: FROM pay_ca_eoy_rl2_employee_info_v emp,
3512: pay_ca_eoy_rl2_trans_info_v tran
3513: WHERE emp.assignment_action_id = p_asg_action_id
3514: AND emp.assignment_id = p_assignment_id
3515: AND emp.payroll_action_id = tran.payroll_action_id;