APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 807: ,pay_element_types_f petf

803: ,eei1.element_type_id
804: from pay_element_type_extra_info eei1
805: ,pay_element_type_extra_info eei2
806: ,hr_lookups hrl
807: ,pay_element_types_f petf
808: where hrl.lookup_type = 'PQP_RATE_TYPE'
809: and hrl.meaning = c_name
810: and eei1.eei_information1 = hrl.lookup_code
811: and eei1.information_type = 'PQP_UK_RATE_TYPE'

Line 904: from pay_element_types_f pet

900: ,c_business_group_id number
901: ) is
902: select pet.element_type_id element_type_id
903: ,piv.input_value_id input_value_id --Vibhor : PTS
904: from pay_element_types_f pet
905: ,pay_input_values_f piv
906: ,pay_balance_feeds_f pbf
907: where pet.element_type_id = piv.element_type_id
908: and pet.business_group_id = NVL(c_business_group_id, g_business_group_id)

Line 2028: ,pay_element_types_f pet

2024: ,pay_payroll_actions BACT
2025: ,pay_assignment_actions ASSACT
2026: ,pay_payroll_actions PACT
2027: ,pay_run_results RR
2028: ,pay_element_types_f pet
2029: ,pay_input_values_f process_iv
2030: ,pay_run_result_values process
2031: ,pay_run_result_values TARGET
2032: ,pay_balance_feeds_f FEED

Line 2101: pay_element_types_f pet,

2097: p_end_date DATE
2098: ) IS
2099: SELECT /*+ ORDERED */ 'N'
2100: FROM pay_run_results prr,
2101: pay_element_types_f pet,
2102: pay_input_values_f process_iv,
2103: pay_run_result_values process
2104: WHERE prr.run_result_id = p_run_result_id
2105: and prr.run_result_id = process.run_result_id