APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ELEMENT_TYPES_F

Line 60: FROM pay_element_types_f petf

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

Line 79: ,pay_element_types_f petf

75: is
76: select pelf.element_link_id,plivf.input_value_id
77: from pay_element_links_f pelf
78: ,pay_link_input_values_f plivf
79: ,pay_element_types_f petf
80: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
81: and petf.legislation_code = 'GB'
82: and petf.element_type_id = pelf.element_type_id
83: and pelf.ELEMENT_LINK_ID = plivf.ELEMENT_LINK_ID

Line 273: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;

269: n_object_version_no number;
270: l_eff_start_date_op date;
271: l_eff_end_date_op date;
272: n_prev_assignment_id per_all_assignments_f.assignment_id%type;
273: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;
274:
275: -- This cursor will fetch assignment ids
276: -- based on the payroll id or assignment id or employee number or assignment set id whichever entered by the user
277:

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