DBA Data[Home] [Help]

APPS.HR_US_REPORTS dependencies on PAY_ELEMENT_TYPES_F

Line 811: pay_element_types_f_tl pet_tl,

807: hr_utility.set_location('hr_us_reports.get_element_type_name',5);
808: SELECT pet_tl.element_name
809: INTO l_element_type_name
810: FROM pay_element_classifications pec,
811: pay_element_types_f_tl pet_tl,
812: pay_element_types_f pet
813: WHERE pet_tl.element_type_id = pet.element_type_id
814: and userenv('LANG') = pet_tl.language
815: and pec.classification_id = pet.classification_id

Line 812: pay_element_types_f pet

808: SELECT pet_tl.element_name
809: INTO l_element_type_name
810: FROM pay_element_classifications pec,
811: pay_element_types_f_tl pet_tl,
812: pay_element_types_f pet
813: WHERE pet_tl.element_type_id = pet.element_type_id
814: and userenv('LANG') = pet_tl.language
815: and pec.classification_id = pet.classification_id
816: AND pet.element_type_id = p_element_type_id;