DBA Data[Home] [Help]

APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_ENTRIES_F

Line 2748: ,pay_element_entries_f pee

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')
2750: AND prr.source_id = pee.element_entry_id
2751: AND pee.CREATOR_TYPE = p_creator_type
2752: AND prv.run_result_id = prr.run_result_id

Line 4569: ,pay_element_entries_f pee

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
4571: AND prr.source_id = pee.element_entry_id
4572: AND pee.CREATOR_TYPE = p_creator_type
4573: AND pbt.balance_name like p_balance_name|| '%'

Line 4618: ,pay_element_entries_f pee

4614: ,pay_run_results prr
4615: ,pay_run_result_values prrv
4616: ,pay_run_result_values prrv1
4617: ,pay_run_result_values prrv2
4618: ,pay_element_entries_f pee
4619: WHERE pbf.balance_type_id = pbt.balance_type_id
4620: AND prr.source_id = pee.element_entry_id
4621: AND pee.CREATOR_TYPE = p_creator_type
4622: AND pbt.balance_name like p_balance_name