APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 27: g_pension_ele_name pay_element_types_f.element_name%TYPE;

23: g_effective_end_date DATE;
24: g_header_system_element ben_ext_rslt_dtl.val_01%TYPE;
25: g_initial_ext_date DATE;
26: g_pension_bal_name pay_balance_types.balance_name%TYPE;
27: g_pension_ele_name pay_element_types_f.element_name%TYPE;
28: g_emp_cont_iv_name pay_input_values_f.NAME%TYPE;
29: g_superann_refno_iv_name pay_input_values_f.NAME%TYPE;
30: g_superann_sal_bal_name pay_balance_types.balance_name%TYPE;
31: g_additional_cont_bal_name pay_balance_types.balance_name%TYPE;

Line 113: FROM pay_element_types_f

109:
110: CURSOR csr_get_pay_ele_id (c_element_name VARCHAR2, c_effective_date DATE)
111: IS
112: SELECT element_type_id
113: FROM pay_element_types_f
114: WHERE element_name = c_element_name
115: AND ( (business_group_id IS NULL AND legislation_code IS NULL)
116: OR ( business_group_id IS NULL
117: AND legislation_code = g_legislation_code

Line 152: FROM pay_element_types_f pet, pay_input_values_f piv

148:
149: CURSOR csr_get_pay_ele_ids_from_bal (c_input_value_id NUMBER)
150: IS
151: SELECT pet.element_type_id element_type_id
152: FROM pay_element_types_f pet, pay_input_values_f piv
153: WHERE pet.element_type_id = piv.element_type_id
154: AND ( ( pet.business_group_id IS NULL
155: AND pet.legislation_code IS NULL
156: )

Line 208: pay_element_types_f pet

204: pee.effective_start_date, pee.effective_end_date
205: FROM pay_element_entries_f pee,
206: pay_element_links_f pel,
207: pay_element_classifications pec,
208: pay_element_types_f pet
209: WHERE pee.assignment_id = c_assignment_id
210: AND pee.entry_type = 'E'
211: AND pee.creation_date BETWEEN c_effective_start_date
212: AND c_effective_end_date

Line 246: pay_element_types_f pet

242: pee.effective_start_date, pee.effective_end_date
243: FROM pay_element_entries_f pee,
244: pay_element_links_f pel,
245: pay_element_classifications pec,
246: pay_element_types_f pet
247: WHERE pee.assignment_id = c_assignment_id
248: AND pee.entry_type = 'E'
249: AND ( pee.effective_start_date BETWEEN c_effective_start_date
250: AND c_effective_end_date

Line 411: -- ,pay_element_types_f pet

407: -- IS
408: -- SELECT pet.element_type_id
409: -- ,pet.element_name
410: -- FROM pay_user_rows_f pur
411: -- ,pay_element_types_f pet
412: -- WHERE pet.element_name = pur.row_low_range_or_name
413: -- AND NVL(pet.business_group_id, g_business_group_id)
414: -- = g_business_group_id
415: -- AND pur.user_table_id = c_user_table_id