APPS.PAY_DB_PAY_US_GROSS dependencies on PAY_ELEMENT_TYPES_F_TL

Line 210: FROM pay_element_types_f_tl type_tl,

206: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 2);
207: --
208: SELECT type.element_type_id
209: INTO v_element_type_id
210: FROM pay_element_types_f_tl type_tl,
211: pay_element_types_f type
212: WHERE type_tl.element_type_id = type.element_type_id
213: and userenv('LANG') = type_tl.language
214: AND nvl(business_group_id, -1) = nvl(g_business_group_ID, -1)

Line 280: pay_element_types_f_tl pet_tl,

276: SELECT piv.input_value_id
277: INTO v_input_value_ID
278: FROM pay_input_values_f_tl piv_tl,
279: pay_input_values_f piv,
280: pay_element_types_f_tl pet_tl,
281: pay_element_types_f pet
282: WHERE piv_tl.input_value_id = piv.input_value_id
283: and pet_tl.element_type_id = pet.element_type_id
284: and userenv('LANG') = piv_tl.language