DBA Data[Home] [Help]

APPS.PAY_CA_RL2_CAN_MAG dependencies on PAY_CA_EOY_RL2_EMPLOYEE_INFO_V

Line 1446: pay_ca_eoy_rl2_employee_info_v emp,

1442: decode(substr(emp.rl2_source_of_income,1,5),'OTHER','AUTRE', emp.rl2_source_of_income),
1443: nvl(emp.negative_balance_flag, 'N'),
1444: emp.person_id
1445: FROM
1446: pay_ca_eoy_rl2_employee_info_v emp,
1447: pay_ca_eoy_rl2_trans_info_v tran
1448: WHERE
1449: emp.assignment_action_id = p_asg_action_id
1450: AND emp.payroll_action_id = tran.payroll_action_id;