APPS.PQP_GB_CPX_EXTRACT_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 28: g_emp_cont_iv_name pay_input_values_f.NAME%TYPE;

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;
32: g_buyback_cont_bal_name pay_balance_types.balance_name%TYPE;

Line 29: g_superann_refno_iv_name pay_input_values_f.NAME%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;
32: g_buyback_cont_bal_name pay_balance_types.balance_name%TYPE;
33:

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 181: FROM pay_input_values_f

177: c_effective_date DATE
178: )
179: IS
180: SELECT input_value_id
181: FROM pay_input_values_f
182: WHERE element_type_id = c_element_type_id
183: AND NAME = c_input_value_name
184: AND ( (business_group_id IS NULL AND legislation_code IS NULL)
185: OR ( business_group_id IS NULL