APPS.HR_AUBAL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 56: from pay_assignment_actions paa

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

Line 131: from pay_assignment_actions paa

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

Line 172: , pay_assignment_actions paa

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

Line 284: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

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

Line 1411: , pay_assignment_actions paa

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

Line 1675: , pay_assignment_actions paa

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

Line 1810: , pay_assignment_actions paa

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