APPS.PQP_US_STUDENT_EARNINGS dependencies on PAY_RUN_RESULTS

Line 66: from pay_run_results prr

62: ,p_element_type_id in number
63: ,p_effective_date in date
64: ,p_input_value_name in varchar2) is
65: select prv.result_value
66: from pay_run_results prr
67: ,pay_run_result_values prv
68: where prr.assignment_action_id = p_asg_action_id
69: and prr.element_type_id = p_element_type_id
70: and prv.input_value_id in

Line 226: ,pay_run_results prr

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
230: and ppa.business_group_id = :1

Line 262: ,pay_run_results prr

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
266: and ppa.business_group_id = :1

Line 350: ,pay_run_results prr

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
354: and ppa.business_group_id = ' || p_business_group_id || '

Line 394: ,pay_run_results prr

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
398: and ppa.business_group_id = ' || p_business_group_id || '

Line 460: ,pay_run_results prr

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
464: and ppa.business_group_id = :1

Line 496: ,pay_run_results prr

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
500: and ppa.business_group_id = :1

Line 554: ,pay_run_results prr

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
558: and ppa.business_group_id = :1

Line 602: ,pay_run_results prr

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
606: and ppa.business_group_id = :1