APPS.PQP_NL_ABP_TEMPLATE dependencies on PAY_FORMULA_RESULT_RULES_F

Line 669: ( result_name pay_formula_result_rules_f.result_name%TYPE

665: l_abp_formula_id NUMBER;
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;

Line 2070: FROM pay_formula_result_rules_f

2066: --
2067: CURSOR c_formula_rules (c_ele_typ_id IN NUMBER) IS
2068: SELECT formula_result_rule_id
2069: ,rowid
2070: FROM pay_formula_result_rules_f
2071: WHERE element_type_id = c_ele_typ_id
2072: AND result_rule_type = 'I'
2073: AND business_group_id = p_business_group_id
2074: FOR UPDATE OF effective_end_date;

Line 2281: UPDATE pay_formula_result_rules_f

2277: -- End Date the formula results row
2278: --
2279: FOR temp_rec IN c_formula_rules (p_pension_dedn_ele_type_id)
2280: LOOP
2281: UPDATE pay_formula_result_rules_f
2282: SET effective_end_date = p_effective_date
2283: WHERE formula_result_rule_id = temp_rec.formula_result_rule_id;
2284: END LOOP;
2285:

Line 2289: UPDATE pay_formula_result_rules_f

2285:
2286: IF l_er_dedn_ele_type_id <> -1 THEN
2287: FOR temp_rec IN c_formula_rules (l_er_dedn_ele_type_id)
2288: LOOP
2289: UPDATE pay_formula_result_rules_f
2290: SET effective_end_date = p_effective_date
2291: WHERE formula_result_rule_id = temp_rec.formula_result_rule_id;
2292: END LOOP;
2293: END IF;