APPS.PQP_GB_PENSION_SCHEME_TEMPLATE dependencies on PAY_INPUT_VALUES_F

Line 173: l_cont_iv_name pay_input_values_f.NAME%TYPE;

169: l_exc_fwd_rule_id VARCHAR2 (1);
170: l_exc_ssal_rule_id VARCHAR2 (1);
171: l_exc_vol_con_rule_id VARCHAR2 (1);
172: l_exc_fsavc_eer_rule_id VARCHAR2 (1);
173: l_cont_iv_name pay_input_values_f.NAME%TYPE;
174: l_skip_formula ff_formulas_f.formula_name%TYPE;
175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;

Line 175: l_iv_default_value pay_input_values_f.default_value%TYPE;

171: l_exc_vol_con_rule_id VARCHAR2 (1);
172: l_exc_fsavc_eer_rule_id VARCHAR2 (1);
173: l_cont_iv_name pay_input_values_f.NAME%TYPE;
174: l_skip_formula ff_formulas_f.formula_name%TYPE;
175: l_iv_default_value pay_input_values_f.default_value%TYPE;
176: l_base_processing_priority pay_element_types_f.processing_priority%TYPE;
177: l_iterative_flag pay_element_types_f.iterative_flag%TYPE;
178: l_iterative_priority pay_element_types_f.iterative_priority%TYPE;
179: l_iterative_formula ff_formulas_f.formula_name%TYPE;

Line 406: FROM pay_input_values_f piv, pay_element_types_f pet

402: IS
403: CURSOR csr_getinput (c_ele_name VARCHAR2, c_iv_name VARCHAR2)
404: IS
405: SELECT piv.input_value_id, piv.NAME, piv.element_type_id
406: FROM pay_input_values_f piv, pay_element_types_f pet
407: WHERE element_name = c_ele_name
408: AND piv.element_type_id = pet.element_type_id
409: AND piv.business_group_id = p_business_group_id
410: AND piv.NAME = c_iv_name;

Line 415: FROM pay_input_values_f

411:
412: CURSOR csr_updinput (c_ip_id NUMBER, c_element_type_id NUMBER)
413: IS
414: SELECT ROWID
415: FROM pay_input_values_f
416: WHERE input_value_id = c_ip_id
417: AND element_type_id = c_element_type_id
418: FOR UPDATE NOWAIT;
419:

Line 455: UPDATE pay_input_values_f

451: hr_utility.set_location (l_proc_name, 30);
452:
453: --
454:
455: UPDATE pay_input_values_f
456: SET default_value = p_def_value
457: WHERE ROWID = csr_updinput_rec.ROWID;
458: END LOOP;
459:

Line 1558: FROM pay_input_values_f

1554: -- Cursor to retrieve the input value information
1555: CURSOR csr_get_ipv_info (c_element_type_id NUMBER)
1556: IS
1557: SELECT input_value_id
1558: FROM pay_input_values_f
1559: WHERE NAME = p_input_value_name
1560: AND element_type_id = c_element_type_id
1561: AND p_effective_start_date BETWEEN effective_start_date
1562: AND effective_end_date;

Line 1646: UPDATE pay_input_values_f

1642: --
1643: hr_utility.set_location (l_proc_name, 20);
1644:
1645: --
1646: UPDATE pay_input_values_f
1647: SET mandatory_flag = p_mandatory_flag
1648: WHERE input_value_id = l_input_value_id
1649: AND p_effective_start_date BETWEEN effective_start_date
1650: AND effective_end_date;