APPS.PAY_HK_AVG_PAY dependencies on PAY_ASSIGNMENT_ACTIONS

Line 16: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

12: ) RETURN DATE IS
13:
14: l_start_date DATE := NULL ;
15: l_date_earned DATE;
16: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
17:
18: CURSOR get_date_earned
19: IS
20: SELECT ppa.date_earned,paa.assignment_id

Line 23: pay_assignment_actions paa

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:
27: BEGIN

Line 182: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

178: l_end_date DATE := NULL ;
179: l_date_earned DATE;
180: l_effective_date DATE;
181: l_hire_date DATE;
182: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
183: l_no_of_days NUMBER;
184:
185: CURSOR get_date_earned
186: IS

Line 190: pay_assignment_actions paa

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:
194: CURSOR csr_hire_date(p_assignment_id in number)