APPS.PQP_US_STUDENT_EARNINGS dependencies on PAY_PAYROLL_ACTIONS

Line 138: l_payroll_id pay_payroll_actions.payroll_id%type;

134: l_assignment_id per_assignments_f.assignment_id%type;
135: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
136: l_element_type_id pay_element_types_f.element_type_id%type;
137: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;
138: l_payroll_id pay_payroll_actions.payroll_id%type;
139:
140: l_proc_name constant varchar2(150):= g_pkg||'Transfer_Student_Earnings';
141:
142: -- =======================================================================

Line 225: ,pay_payroll_actions ppa

221: ,ppa.payroll_id
222: ,prr.element_type_id
223:
224: from pay_assignment_actions paa
225: ,pay_payroll_actions ppa
226: ,pay_run_results prr
227: where ppa.action_status = ''C''
228: and paa.action_status = ''C''
229: and paa.payroll_action_id = ppa.payroll_action_id

Line 261: ,pay_payroll_actions ppa

257: ,ppa.payroll_id
258: ,prr.element_type_id
259:
260: from pay_assignment_actions paa
261: ,pay_payroll_actions ppa
262: ,pay_run_results prr
263: where ppa.action_status = ''C''
264: and paa.action_status = ''C''
265: and paa.payroll_action_id = ppa.payroll_action_id

Line 349: ,pay_payroll_actions ppa

345: ,ppa.payroll_id
346: ,prr.element_type_id
347:
348: from pay_assignment_actions paa
349: ,pay_payroll_actions ppa
350: ,pay_run_results prr
351: where ppa.action_status = ''C''
352: and paa.action_status = ''C''
353: and paa.payroll_action_id = ppa.payroll_action_id

Line 393: ,pay_payroll_actions ppa

389: ,ppa.payroll_id
390: ,prr.element_type_id
391:
392: from pay_assignment_actions paa
393: ,pay_payroll_actions ppa
394: ,pay_run_results prr
395: where ppa.action_status = ''C''
396: and paa.action_status = ''C''
397: and paa.payroll_action_id = ppa.payroll_action_id

Line 459: ,pay_payroll_actions ppa

455: ,ppa.payroll_id
456: ,prr.element_type_id
457:
458: from pay_assignment_actions paa
459: ,pay_payroll_actions ppa
460: ,pay_run_results prr
461: where ppa.action_status = ''C''
462: and paa.action_status = ''C''
463: and paa.payroll_action_id = ppa.payroll_action_id

Line 495: ,pay_payroll_actions ppa

491: ,ppa.payroll_id
492: ,prr.element_type_id
493:
494: from pay_assignment_actions paa
495: ,pay_payroll_actions ppa
496: ,pay_run_results prr
497: where ppa.action_status = ''C''
498: and paa.action_status = ''C''
499: and paa.payroll_action_id = ppa.payroll_action_id

Line 553: ,pay_payroll_actions ppa

549: ,ppa.payroll_id
550: ,prr.element_type_id
551:
552: from pay_assignment_actions paa
553: ,pay_payroll_actions ppa
554: ,pay_run_results prr
555: where ppa.action_status = ''C''
556: and paa.action_status = ''C''
557: and paa.payroll_action_id = ppa.payroll_action_id

Line 601: ,pay_payroll_actions ppa

597: ,ppa.payroll_id
598: ,prr.element_type_id
599:
600: from pay_assignment_actions paa
601: ,pay_payroll_actions ppa
602: ,pay_run_results prr
603: where ppa.action_status = ''C''
604: and paa.action_status = ''C''
605: and paa.payroll_action_id = ppa.payroll_action_id