APPS.PAY_CA_RL2_MAG dependencies on PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Line 302: from pay_ca_eoy_rl2_employee_info_v emp,

298: p_sqlstr := 'select /*+ leading(ppa_mag,ppa_arch,paa_arch)
299: index(emp.paa_arch,PAY_ASSIGNMENT_ACTIONS_PK)
300: use_hash(emp.ppa_arch,hoi,tran.ppa_arch)
301: */ distinct to_number(emp.person_id)
302: from pay_ca_eoy_rl2_employee_info_v emp,
303: pay_ca_eoy_rl2_trans_info_v tran,
304: pay_assignment_actions paa_arch,
305: pay_payroll_actions ppa_arch,
306: pay_payroll_actions ppa_mag,

Line 1333: FROM pay_ca_eoy_rl2_employee_info_v emp,

1329: lookup_code = p_lookup_code;
1330:
1331: CURSOR c_employee_infor (p_asg_action_id IN number) IS
1332: SELECT nvl(emp.negative_balance_flag, 'N')
1333: FROM pay_ca_eoy_rl2_employee_info_v emp,
1334: pay_ca_eoy_rl2_trans_info_v tran
1335: WHERE emp.assignment_action_id = p_asg_action_id
1336: AND emp.payroll_action_id = tran.payroll_action_id;
1337:

Line 1340: FROM pay_ca_eoy_rl2_employee_info_v emp,

1336: AND emp.payroll_action_id = tran.payroll_action_id;
1337:
1338: CURSOR c_employee_amend_infor (p_asg_action_id IN number) IS
1339: SELECT nvl(emp.negative_balance_flag, 'N')
1340: FROM pay_ca_eoy_rl2_employee_info_v emp,
1341: pay_ca_eoy_rl2_emp_info2_v emp2,
1342: pay_ca_eoy_rl2_trans_info_v tran
1343: WHERE emp.assignment_action_id = p_asg_action_id
1344: AND emp.assignment_action_id = emp2.assignment_action_id

Line 1709: FROM pay_ca_eoy_rl2_employee_info_v emp,

1705: emp.rl2_box_o,
1706: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1707: nvl(emp.negative_balance_flag, 'N'),
1708: emp.person_id
1709: FROM pay_ca_eoy_rl2_employee_info_v emp,
1710: pay_ca_eoy_rl2_trans_info_v tran
1711: WHERE emp.assignment_action_id = p_asg_action_id
1712: AND emp.payroll_action_id = tran.payroll_action_id;
1713:

Line 1750: FROM pay_ca_eoy_rl2_employee_info_v emp,

1746: emp.rl2_box_o,
1747: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1748: nvl(emp.negative_balance_flag, 'N'),
1749: emp.person_id
1750: FROM pay_ca_eoy_rl2_employee_info_v emp,
1751: pay_ca_eoy_rl2_emp_info2_v emp2,
1752: pay_ca_eoy_rl2_trans_info_v tran
1753: WHERE emp.assignment_action_id = p_asg_action_id
1754: AND emp.assignment_action_id = emp2.assignment_action_id

Line 5135: FROM pay_ca_eoy_rl2_employee_info_v emp,

5131: emp.rl2_box_o,
5132: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
5133: nvl(emp.negative_balance_flag, 'N'),
5134: emp.person_id
5135: FROM pay_ca_eoy_rl2_employee_info_v emp,
5136: pay_ca_eoy_rl2_trans_info_v tran
5137: WHERE emp.assignment_action_id = p_asg_action_id
5138: AND emp.assignment_id = p_assignment_id
5139: AND emp.payroll_action_id = tran.payroll_action_id;