DBA Data[Home] [Help]

APPS.PQP_GB_T1_PENSION_EXTRACTS dependencies on PAY_ELEMENT_TYPES_F

Line 803: ,pay_element_types_f petf

799: ,eei1.element_type_id
800: from pay_element_type_extra_info eei1
801: ,pay_element_type_extra_info eei2
802: ,hr_lookups hrl
803: ,pay_element_types_f petf
804: where hrl.lookup_type = 'PQP_RATE_TYPE'
805: and hrl.meaning = c_name
806: and eei1.eei_information1 = hrl.lookup_code
807: and eei1.information_type = 'PQP_UK_RATE_TYPE'

Line 897: from pay_element_types_f pet

893: ,c_business_group_id number
894: ) is
895: select pet.element_type_id element_type_id
896: ,piv.input_value_id input_value_id --Vibhor : PTS
897: from pay_element_types_f pet
898: ,pay_input_values_f piv
899: ,pay_balance_feeds_f pbf
900: where pet.element_type_id = piv.element_type_id
901: and pet.business_group_id = NVL(c_business_group_id, g_business_group_id)

Line 2067: pay_element_types_f pet,

2063: p_end_date DATE
2064: ) IS
2065: SELECT /*+ ORDERED */ 'N'
2066: FROM pay_run_results prr,
2067: pay_element_types_f pet,
2068: pay_input_values_f process_iv,
2069: pay_run_result_values process
2070: WHERE prr.run_result_id = p_run_result_id
2071: and prr.run_result_id = process.run_result_id