DBA Data[Home] [Help]

APPS.PAY_HK_AVG_PAY dependencies on PAY_PAYROLL_ACTIONS

Line 22: pay_payroll_actions ppa,

18: CURSOR get_date_earned
19: IS
20: SELECT ppa.date_earned,paa.assignment_id
21: FROM
22: pay_payroll_actions ppa,
23: pay_assignment_actions paa
24: WHERE paa.assignment_action_id = p_assignment_action_id
25: AND ppa.payroll_action_id=paa.payroll_action_id;
26:

Line 189: pay_payroll_actions ppa,

185: CURSOR get_date_earned
186: IS
187: SELECT ppa.date_earned,paa.assignment_id,ppa.effective_date
188: FROM
189: pay_payroll_actions ppa,
190: pay_assignment_actions paa
191: WHERE paa.assignment_action_id = p_assignment_action_id
192: AND ppa.payroll_action_id=paa.payroll_action_id;
193: