DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on PAY_ELEMENT_TYPES_F

Line 793: pay_element_types_f_tl pet_tl,

789: hr_utility.set_location('hr_us_reports.get_element_type_name',5);
790: SELECT pet_tl.element_name
791: INTO l_element_type_name
792: FROM pay_element_classifications pec,
793: pay_element_types_f_tl pet_tl,
794: pay_element_types_f pet
795: WHERE pet_tl.element_type_id = pet.element_type_id
796: and userenv('LANG') = pet_tl.language
797: and pec.classification_id = pet.classification_id

Line 794: pay_element_types_f pet

790: SELECT pet_tl.element_name
791: INTO l_element_type_name
792: FROM pay_element_classifications pec,
793: pay_element_types_f_tl pet_tl,
794: pay_element_types_f pet
795: WHERE pet_tl.element_type_id = pet.element_type_id
796: and userenv('LANG') = pet_tl.language
797: and pec.classification_id = pet.classification_id
798: AND pet.element_type_id = p_element_type_id;