DBA Data[Home] [Help]

APPS.PAY_AU_REC_DET_PAYSUM_MODE dependencies on PAY_ELEMENT_TYPES_F

Line 1558: from pay_element_types_f pet

1554: 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 */
1555: prr.run_result_id,
1556: paa.source_action_id
1557: ,nvl(pet.element_information2,0) balance_type_id
1558: from pay_element_types_f pet
1559: ,pay_input_values_f piv1
1560: ,pay_element_classifications pec
1561: ,pay_assignment_actions paa
1562: ,pay_payroll_actions ppa

Line 1601: pay_element_types_f pet1

1597: and NOT EXISTS
1598: (
1599: select 1
1600: from pay_run_results prr1,
1601: pay_element_types_f pet1
1602: where prr1.assignment_action_id = paa.assignment_action_id
1603: and prr1.element_type_id = pet1.element_type_id
1604: and pet1.element_name in ('Retropay GT 12 Mths Amount')
1605: and prr1.source_id = prr.source_id

Line 2465: FROM pay_element_types_f pet

2461: ,c_end_date date
2462: ,c_tax_unit_id pay_assignment_actions.tax_unit_id%type)
2463: IS
2464: SELECT DISTINCT pet.element_information2 balance_type_id
2465: FROM pay_element_types_f pet
2466: ,per_all_assignments_f paf
2467: ,pay_payroll_actions ppa
2468: ,pay_assignment_actions paa
2469: ,pay_run_results prr