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 50: ,pay_element_entries_f peef

46: is
47: SELECT peevf.element_entry_id
48: ,peevf.input_value_id
49: FROM pay_element_types_f petf
50: ,pay_element_entries_f peef
51: ,pay_element_entry_values_f peevf
52: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
53: and petf.legislation_code = 'GB'
54: -- and petf.business_group_id = p_business_group_id 6652351

Line 351: FROM pay_element_entries_f peef, pay_element_types_f petf

347: --This cursor will fetch the all elements for the assigment
348: CURSOR c1_all_element(n_assignment_id NUMBER)
349: IS
350: SELECT peef.ELEMENT_TYPE_ID,petf.ELEMENT_NAME
351: FROM pay_element_entries_f peef, pay_element_types_f petf
352: WHERE peef.ASSIGNMENT_ID=n_assignment_id
353: AND peef.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
354: AND petf.business_group_id = p_business_group_id
355: AND v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE