DBA Data[Home] [Help]

APPS.PAY_CA_RL2_MAG dependencies on PAY_CA_EOY_RL2_EMP_INFO2_V

Line 1341: pay_ca_eoy_rl2_emp_info2_v emp2,

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
1345: AND emp.payroll_action_id = emp2.payroll_action_id

Line 1751: pay_ca_eoy_rl2_emp_info2_v emp2,

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
1755: AND emp.payroll_action_id = emp2.payroll_action_id