APPS.PQP_US_STUDENT_EARNINGS dependencies on PAY_ASSIGNMENT_ACTIONS

Line 135: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;

131: l_grp_party_id per_people_f.party_id%type := null;
132: l_chk_grp_party_id per_people_f.party_id%type := null;
133: l_ssn per_people_f.national_identifier%type := null;
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:

Line 137: l_tax_unit_id pay_assignment_actions.tax_unit_id%type;

133: l_ssn per_people_f.national_identifier%type := null;
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:

Line 224: from pay_assignment_actions paa

220: ,ppa.date_earned
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''

Line 260: from pay_assignment_actions paa

256: ,ppa.date_earned
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''

Line 348: from pay_assignment_actions paa

344: ,ppa.date_earned
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''

Line 392: from pay_assignment_actions paa

388: ,ppa.date_earned
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''

Line 458: from pay_assignment_actions paa

454: ,ppa.date_earned
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''

Line 494: from pay_assignment_actions paa

490: ,ppa.date_earned
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''

Line 552: from pay_assignment_actions paa

548: ,ppa.date_earned
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''

Line 600: from pay_assignment_actions paa

596: ,ppa.date_earned
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''