APPS.PAY_AU_PAYMENT_SUMMARY dependencies on PAY_RUN_RESULTS

Line 2721: ,pay_run_results prr

2717: ,per_periods_of_service pps
2718: ,pay_assignment_actions pac
2719: ,pay_payroll_actions ppa
2720: ,pay_element_entries_f pee
2721: ,pay_run_results prr
2722: ,pay_element_types_f pet
2723: /* below added for bug 7571001 */
2724: ,PAY_BAL_ATTRIBUTE_DEFINITIONS pbad
2725: , PAY_BALANCE_ATTRIBUTES pba

Line 2772: pay_run_results prr,

2768: select NVL(pbt.reporting_name,pbt.balance_name) balance_name /* Bug 5743196 Added nvl */
2769: ,prv.result_value balance_value
2770: from
2771: pay_element_entries_f pee,
2772: pay_run_results prr,
2773: pay_run_result_values prv,
2774: pay_element_types_f pet,
2775: pay_balance_types pbt
2776: /* below added for bug 7571001 */

Line 4444: ,pay_run_results prr

4440: ,ppa.effective_date
4441: from pay_element_types_f pet
4442: ,pay_input_values_f piv
4443: ,per_all_assignments_f paa
4444: ,pay_run_results prr
4445: ,pay_run_result_values prv
4446: ,pay_assignment_actions pac
4447: ,pay_payroll_actions ppa
4448: ,pay_payrolls_f papf /* bug Number 4278361 */

Line 4653: , pay_run_results prr

4649: , pay_balance_types pbt
4650: , pay_defined_balances pdb
4651: , pay_payroll_actions ppa
4652: , pay_assignment_actions pac
4653: , pay_run_results prr
4654: , pay_balance_feeds_f pbf
4655: , pay_input_values_f piv
4656: where pac.assignment_id = p_assignment_id
4657: and pac.tax_unit_id = p_registered_employer

Line 5241: ,pay_run_results prr

5237: select prv.result_value INPUT_VALUE,piv.name INPUT_NAME
5238: from pay_element_types_f pet
5239: ,pay_input_values_f piv
5240: ,per_all_assignments_f paa
5241: ,pay_run_results prr
5242: ,pay_run_result_values prv
5243: ,pay_assignment_actions pac
5244: ,pay_payroll_actions ppa
5245: where pet.element_type_id = piv.element_type_id

Line 5996: FROM pay_run_results prr

5992: SELECT pet.element_name
5993: ,to_char(ppa.effective_date,'DDMMYYYY') run_effective_date
5994: ,pac.assignment_action_id
5995: ,ppa.payroll_action_id
5996: FROM pay_run_results prr
5997: ,per_all_assignments_f paaf
5998: ,pay_assignment_actions pac
5999: ,pay_payroll_actions ppa
6000: ,pay_payrolls_f papf

Line 8280: pay_run_results prr

8276: FROM pay_assignment_actions paa,
8277: pay_payroll_actions ppa,
8278: per_assignments_f paf,
8279: pay_element_types_f pet,
8280: pay_run_results prr
8281: WHERE paa.assignment_id = paf.assignment_id
8282: AND paf.assignment_id = c_assignment_id
8283: AND ppa.payroll_action_id = paa.payroll_action_id
8284: AND ppa.effective_date BETWEEN c_year_start AND c_year_end

Line 9651: ,pay_run_results prr

9647: ,per_periods_of_service pps
9648: ,pay_assignment_actions pac
9649: ,pay_payroll_actions ppa
9650: ,pay_element_entries_f pee
9651: ,pay_run_results prr
9652: ,pay_run_result_values prv
9653: ,pay_element_types_f pet
9654: ,pay_input_values_f piv
9655: ,pay_element_classifications pec