APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F_TL

Line 2745: ,pay_element_types_f_tl pettl

2741:
2742: FROM pay_run_result_values prv
2743: ,pay_run_results prr
2744: ,pay_element_types_f pet
2745: ,pay_element_types_f_tl pettl
2746: ,pay_input_values_f piv
2747: ,pay_element_classifications pec
2748: ,pay_element_entries_f pee
2749: WHERE prr.status IN ('P','PA')

Line 2778: ,pay_element_types_f_tl pettl

2774: SELECT unique prr.start_date --(pay_nl_general.get_retro_period(prr.source_id,p_date_earned)) Bug 5107780
2775: FROM pay_run_result_values prv
2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2779: ,pay_input_values_f piv
2780: ,pay_element_classifications pec
2781: WHERE prr.status IN ('P','PA')
2782: AND prv.run_result_id = prr.run_result_id

Line 2816: ,pay_element_types_f_tl pettl

2812: ,prv.run_result_id run_result_id /* 4389520*/
2813: FROM pay_run_result_values prv
2814: ,pay_run_results prr
2815: ,pay_element_types_f pet
2816: ,pay_element_types_f_tl pettl
2817: ,pay_input_values_f piv
2818: ,pay_element_classifications pec
2819: WHERE prr.status IN ('P','PA')
2820: AND prv.run_result_id = prr.run_result_id

Line 4566: -- ,pay_element_types_f_tl pettl Bug 5107780

4562: FROM pay_balance_feeds_f pbf
4563: ,pay_balance_types pbt
4564: ,pay_input_values_f piv
4565: ,pay_element_types_f pet
4566: -- ,pay_element_types_f_tl pettl Bug 5107780
4567: ,pay_run_results prr
4568: ,pay_run_result_values prrv
4569: ,pay_element_entries_f pee
4570: WHERE pbf.balance_type_id = pbt.balance_type_id

Line 4613: -- ,pay_element_types_f_tl pettl Bug 5107780

4609: ,pay_input_values_f piv
4610: ,pay_input_values_f piv1
4611: ,pay_input_values_f piv2
4612: ,pay_element_types_f pet
4613: -- ,pay_element_types_f_tl pettl Bug 5107780
4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2