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_LGPS_PENSIONPAY 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 349: FROM pay_element_entries_f peef, pay_element_types_f petf

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