APPS.PQP_GB_SCOTLAND_LGPS_PENSIONPY dependencies on PAY_ELEMENT_TYPES_F

Line 49: FROM pay_element_types_f petf

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

Line 68: ,pay_element_types_f petf

64: is
65: select pelf.element_link_id,plivf.input_value_id
66: from pay_element_links_f pelf
67: ,pay_link_input_values_f plivf
68: ,pay_element_types_f petf
69: where petf.element_name = 'PQP LGPS Additional Pensionable Pay'
70: and petf.legislation_code = 'GB'
71: and petf.element_type_id = pelf.element_type_id
72: and pelf.ELEMENT_LINK_ID = plivf.ELEMENT_LINK_ID

Line 261: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;

257: n_object_version_no number;
258: l_eff_start_date_op date;
259: l_eff_end_date_op date;
260: n_prev_assignment_id per_all_assignments_f.assignment_id%type;
261: l_ELEMENT_NAME pay_element_types_f.ELEMENT_NAME%TYPE;
262:
263: -- This cursor will fetch assignment ids
264: -- based on the payroll id or assignment id or employee number or assignment set id whichever entered by the user
265:

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