APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 176: FROM pay_input_values_f

172: --
173: CURSOR csr_ipv (c_ele_typeid NUMBER
174: ,c_effective_date date) IS
175: SELECT input_value_id
176: FROM pay_input_values_f
177: WHERE element_type_id = c_ele_typeid
178: AND business_group_id = p_business_group_id
179: AND name = 'Pay Value'
180: AND c_effective_date BETWEEN effective_start_date

Line 670: ,input_value_id pay_input_values_f.input_value_id%TYPE

666: l_subcat VARCHAR2(30);
667: --
668: TYPE r_input_result IS RECORD
669: ( result_name pay_formula_result_rules_f.result_name%TYPE
670: ,input_value_id pay_input_values_f.input_value_id%TYPE
671: );
672: --
673: TYPE t_input_result IS TABLE of r_input_result INDEX BY BINARY_INTEGER;
674: --

Line 681: FROM pay_input_values_f

677: CURSOR c_ip_val
678: ( c_element_type_id IN NUMBER
679: ,c_name IN VARCHAR2) IS
680: SELECT input_value_id
681: FROM pay_input_values_f
682: WHERE element_type_id = c_element_type_id
683: AND trunc(p_scheme_start_date) BETWEEN
684: effective_start_date AND effective_end_date
685: AND name = c_name ;