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_TYPES_F

Line 69: FROM pay_element_types_f petf

65: ,p_effective_date date)
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'

Line 89: ,pay_element_types_f petf

85: is
86: select pelf.element_link_id,plivf.input_value_id
87: from pay_element_links_f pelf
88: ,pay_link_input_values_f plivf
89: ,pay_element_types_f petf
90: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
91: and petf.legislation_code = 'GB'
92: and petf.element_type_id = pelf.element_type_id
93: and pelf.ELEMENT_LINK_ID = plivf.ELEMENT_LINK_ID

Line 299: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;

295: n_object_version_no number;
296: l_eff_start_date_op date;
297: l_eff_end_date_op date;
298: n_prev_assignment_id per_all_assignments_f.assignment_id%type;
299: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;
300:
301: -- This cursor will fetch assignment ids
302: -- based on the payroll id or assignment id or employee number or assignment set id whichever entered by the user
303:

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 441: from pay_element_types_f petf

437: -- This cursor to fetch element_type_id
438: cursor c_pqp_element_type_id(p_element_name varchar2)
439: is
440: select element_type_id
441: from pay_element_types_f petf
442: where UPPER(petf.element_name) = UPPER(p_element_name)
443: and petf.business_group_id = p_business_group_id
444: and v_assignment_eff_date between petf.EFFECTIVE_START_DATE and petf.EFFECTIVE_END_DATE;
445: