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

Line 70: ,pay_element_entries_f peef

66: is
67: SELECT peevf.element_entry_id
68: ,peevf.input_value_id
69: FROM pay_element_types_f petf
70: ,pay_element_entries_f peef
71: ,pay_element_entry_values_f peevf
72: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
73: and petf.legislation_code = 'GB'
74: -- and petf.business_group_id = p_business_group_id 6652351

Line 387: FROM pay_element_entries_f peef, pay_element_types_f petf

383: --This cursor will fetch the all elements for the assigment
384: CURSOR c1_all_element(n_assignment_id NUMBER)
385: IS
386: SELECT peef.ELEMENT_TYPE_ID,petf.ELEMENT_NAME
387: FROM pay_element_entries_f peef, pay_element_types_f petf
388: WHERE peef.ASSIGNMENT_ID=n_assignment_id
389: AND peef.ELEMENT_TYPE_ID = petf.ELEMENT_TYPE_ID
390: AND petf.business_group_id = p_business_group_id
391: AND peef.entry_type = 'E' --9950842

Line 450: from pay_element_entries_f peef

446: --This cursor to fetch element_entry_id
447: cursor c_pqp_element_entry_id(p_element_type_id number,p_assignment_id per_all_assignments_f.assignment_id%type)
448: is
449: select element_entry_id
450: from pay_element_entries_f peef
451: where peef.element_type_id = p_element_type_id
452: and peef.assignment_id = p_assignment_id
453: and v_assignment_eff_date between peef.EFFECTIVE_START_DATE and peef.EFFECTIVE_END_DATE;
454: