eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_GB_PENSION_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 31: ,pay_element_types_f pet

27: AND entry_type = 'E'
28: AND EXISTS (
29: SELECT 1
30: FROM pay_element_links_f pel
31: ,pay_element_types_f pet
32: ,pay_element_classifications pec
33: WHERE pel.element_link_id = pee.element_link_id
34: AND pel.element_type_id <> c_element_type_id
35: AND pet.element_type_id = pel.element_type_id

Line 82: FROM pay_element_types_f pet

78: ,c_pension_category VARCHAR2
79: )
80: IS
81: SELECT 'X'
82: FROM pay_element_types_f pet
83: WHERE pet.element_type_id = c_element_type_id
84: AND c_effective_date BETWEEN pet.effective_start_date
85: AND pet.effective_end_date
86: AND EXISTS ( SELECT 1

Line 166: FROM pay_element_types_f

162: -- Cursor to get element name
163: CURSOR csr_get_ele_name (c_element_type_id NUMBER, c_effective_date DATE)
164: IS
165: SELECT element_name
166: FROM pay_element_types_f
167: WHERE element_type_id = c_element_type_id
168: AND c_effective_date BETWEEN effective_start_date
169: AND effective_end_date;
170: