DBA Data[Home] [Help]

APPS.PQH_FR_UTILITY dependencies on PAY_ELEMENT_TYPES_F

Line 2139: ,pay_element_types_f pet

2135: IS
2136: CURSOR c_payment_cur IS
2137: SELECT pettl.element_name
2138: FROM pay_element_classifications pec
2139: ,pay_element_types_f pet
2140: ,pay_element_types_f_tl pettl
2141: WHERE(pet.business_group_id = p_business_group_id OR
2142: (pet.business_group_id IS NULL AND pet.legislation_code = 'FR'))
2143: AND pet.element_type_id = p_payment_code

Line 2140: ,pay_element_types_f_tl pettl

2136: CURSOR c_payment_cur IS
2137: SELECT pettl.element_name
2138: FROM pay_element_classifications pec
2139: ,pay_element_types_f pet
2140: ,pay_element_types_f_tl pettl
2141: WHERE(pet.business_group_id = p_business_group_id OR
2142: (pet.business_group_id IS NULL AND pet.legislation_code = 'FR'))
2143: AND pet.element_type_id = p_payment_code
2144: AND pet.element_type_id = pettl.element_type_id