APPS.PAY_AU_SGC_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 136: from pay_assignment_actions paa

132: cursor get_latest_id ( c_assignment_id in number --Bug#2610141
133: , c_effective_date in date
134: ) is
135: select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
136: from pay_assignment_actions paa
137: , pay_payroll_actions ppa
138: where paa.assignment_id = c_assignment_id
139: and ppa.payroll_action_id = paa.payroll_action_id
140: and ppa.effective_date <= c_effective_date

Line 161: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141

157: l_bal_id pay_balance_types.balance_type_id%type;
158: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
159: l_salary number;
160: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
161: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
162: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
163:
164:
165:

Line 308: from pay_assignment_actions paa

304: cursor get_latest_id ( c_assignment_id in number --Bug#2610141
305: , c_effective_date in date
306: ) is
307: select /*+ORDERED*/ to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
308: from pay_assignment_actions paa
309: , pay_payroll_actions ppa
310: where paa.assignment_id = c_assignment_id
311: and ppa.payroll_action_id = paa.payroll_action_id
312: and ppa.effective_date <= c_effective_date

Line 330: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141

326: l_bal_id pay_balance_types.balance_type_id%type;
327: l_bal_id_mtd pay_balance_types.balance_type_id%type; --2610141
328: l_salary number;
329: l_bal_id_min_superable_sal pay_balance_types.balance_type_id%type;
330: l_assignment_action_id pay_assignment_actions.assignment_action_id%type; --2610141
331: l_super_guarantee_bal_id_qtd pay_defined_balances.defined_balance_id%type; --2610141
332:
333:
334: begin