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_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ELEMENT_ENTRIES_F

Line 61: ,pay_element_entries_f peef

57: is
58: SELECT peevf.element_entry_id
59: ,peevf.input_value_id
60: FROM pay_element_types_f petf
61: ,pay_element_entries_f peef
62: ,pay_element_entry_values_f peevf
63: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
64: and petf.legislation_code = 'GB'
65: -- and petf.business_group_id = p_business_group_id 6652351

Line 364: FROM pay_element_entries_f peef, pay_element_types_f petf

360: --This cursor will fetch the all elements for the assigment
361: CURSOR c1_all_element(n_assignment_id NUMBER)
362: IS
363: SELECT peef.ELEMENT_TYPE_ID,petf.ELEMENT_NAME
364: FROM pay_element_entries_f peef, pay_element_types_f petf
365: WHERE peef.ASSIGNMENT_ID=n_assignment_id
366: AND peef.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
367: AND petf.business_group_id = p_business_group_id
368: AND peef.entry_type = 'E' --9950842