APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_ELEMENT_TYPES_F

Line 2489: from pay_element_types_f pet

2485: (prrv1.result_value/pay_au_rec_det_archive.get_element_payment_hours(prr.assignment_action_id,pet.element_type_id,prr.run_result_id, ppa.effective_date)),
2486: pay_au_rec_det_archive.get_element_payment_rate(prr.assignment_action_id,pet.element_type_id,prr.run_result_id,ppa.effective_date)) rate, /* 5599310 */
2487: prr.run_result_id,
2488: paa.source_action_id
2489: from pay_element_types_f pet
2490: ,pay_input_values_f piv1
2491: ,pay_element_classifications pec
2492: ,pay_assignment_actions paa
2493: ,pay_payroll_actions ppa

Line 2534: pay_element_types_f pet1

2530: and NOT EXISTS
2531: (
2532: select 1
2533: from pay_run_results prr1,
2534: pay_element_types_f pet1
2535: where prr1.assignment_action_id = paa.assignment_action_id
2536: and prr1.element_type_id = pet1.element_type_id
2537: and pet1.element_name in ('Retropay GT 12 Mths Amount',
2538: 'Retro Pre Tax GT 12 Mths Amount', /*start 9190980*/

Line 2605: ,pay_element_types_f pet

2601: per_all_assignments_f paa
2602: ,pay_assignment_actions pac
2603: ,pay_payroll_actions ppa
2604: ,pay_run_results prr
2605: ,pay_element_types_f pet
2606: ,pay_input_values_f piv
2607: ,pay_run_result_values prrv
2608: ,pay_balance_feeds_f pbf
2609: ,pay_defined_balances pdb