APPS.HR_AUBAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 55: from pay_assignment_actions paa

51: l_assignment_id number;
52: --
53: cursor get_corr_type ( c_assignment_action_id in number ) is
54: select assignment_id
55: from pay_assignment_actions paa
56: , pay_payroll_actions ppa
57: where paa.assignment_action_id = c_assignment_action_id
58: and ppa.payroll_action_id = paa.payroll_action_id
59: and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');

Line 130: , pay_assignment_actions paa

126: , c_effective_date in date
127: ) is
128: select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
129: from per_assignments_f paf
130: , pay_assignment_actions paa
131: , pay_payroll_actions ppa
132: where paa.assignment_id = c_assignment_id
133: and paf.assignment_id = paa.assignment_id
134: and ppa.payroll_action_id = paa.payroll_action_id

Line 169: , pay_assignment_actions paa

165: --
166: cursor c_bal_date is
167: select ppa.effective_date
168: from pay_payroll_actions ppa
169: , pay_assignment_actions paa
170: where paa.payroll_action_id = ppa.payroll_action_id
171: and paa.assignment_action_id = p_assignment_action_id;
172: --
173: begin

Line 281: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

277: )
278: return number
279: is
280: --
281: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
282: --
283: begin
284: --
285: l_assignment_action_id := get_latest_action_id( p_assignment_id, p_effective_date );

Line 1408: , pay_assignment_actions paa

1404: cursor expired_time_period (c_assignment_action_id number) is
1405: select ptp.end_date
1406: from per_time_periods ptp
1407: , pay_payroll_actions ppa
1408: , pay_assignment_actions paa
1409: where paa.assignment_action_id = c_assignment_action_id
1410: and paa.payroll_action_id = ppa.payroll_action_id
1411: and ppa.time_period_id = ptp.time_period_id;
1412: --

Line 1672: , pay_assignment_actions paa

1668: cursor expired_time_period ( c_assignment_action_id in number ) is
1669: select ptp.end_date
1670: from per_time_periods ptp
1671: , pay_payroll_actions ppa
1672: , pay_assignment_actions paa
1673: where paa.assignment_action_id = c_assignment_action_id
1674: and paa.payroll_action_id = ppa.payroll_action_id
1675: and ppa.time_period_id = ptp.time_period_id;
1676: --

Line 1807: , pay_assignment_actions paa

1803: cursor expired_time_period( c_assignment_action_id in number ) is
1804: select ptp.end_date
1805: from per_time_periods ptp
1806: , pay_payroll_actions ppa
1807: , pay_assignment_actions paa
1808: where paa.assignment_action_id = c_assignment_action_id
1809: and paa.payroll_action_id = ppa.payroll_action_id
1810: and ppa.time_period_id = ptp.time_period_id;
1811: --