APPS.PAY_ES_RUN_TYPES dependencies on PAY_ELEMENT_TYPES_F

Line 23: FROM pay_element_types_f pet

19: ,pet.business_group_id
20: ,pet.legislation_code
21: ,pet.indirect_only_flag
22: ,MIN(pet.effective_start_date) effective_date
23: FROM pay_element_types_f pet
24: ,per_business_groups pbg
25: WHERE Nvl(pet.indirect_only_flag, 'N') = 'N'
26: AND pet.business_group_id = c_business_group_id
27: AND pbg.business_group_id = pet.business_group_id

Line 111: FROM pay_element_types_f pet

107: CURSOR csr_get_element_print_info(c_element_type_id NUMBER
108: ,c_effective_date DATE ) IS
109: SELECT petl.element_name element_name
110: ,pecl.classification_name classification_name
111: FROM pay_element_types_f pet
112: ,pay_element_types_f_tl petl
113: ,pay_element_classifications_tl pecl
114: WHERE pet.element_type_id = c_element_type_id
115: AND pet.element_type_id = petl.element_type_id

Line 112: ,pay_element_types_f_tl petl

108: ,c_effective_date DATE ) IS
109: SELECT petl.element_name element_name
110: ,pecl.classification_name classification_name
111: FROM pay_element_types_f pet
112: ,pay_element_types_f_tl petl
113: ,pay_element_classifications_tl pecl
114: WHERE pet.element_type_id = c_element_type_id
115: AND pet.element_type_id = petl.element_type_id
116: AND petl.language = USERENV('LANG')