APPS.HR_AUBAL dependencies on PAY_PAYROLL_ACTIONS

Line 57: , pay_payroll_actions ppa

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');
61: --

Line 133: , pay_payroll_actions ppa

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
136: and paf.assignment_id = paa.assignment_id
137: and ppa.payroll_action_id = paa.payroll_action_id

Line 171: from pay_payroll_actions ppa

167: l_effective_date date;
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: --

Line 1410: , pay_payroll_actions ppa

1406: --
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;

Line 1674: , pay_payroll_actions ppa

1670: --
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;

Line 1809: , pay_payroll_actions ppa

1805: --
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;