APPS.PAY_CN_ELEMENT_TEMPLATE_PKG dependencies on PAY_FORMULA_RESULT_RULES_F

Line 290: v_form_res_rule_id pay_formula_result_rules_f.formula_result_rule_id%TYPE;

286: )
287: IS
288:
289: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
290: v_form_res_rule_id pay_formula_result_rules_f.formula_result_rule_id%TYPE;
291: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
292: l_element_type_id pay_element_types_f.element_type_id%TYPE;
293: BEGIN
294:

Line 291: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;

287: IS
288:
289: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
290: v_form_res_rule_id pay_formula_result_rules_f.formula_result_rule_id%TYPE;
291: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
292: l_element_type_id pay_element_types_f.element_type_id%TYPE;
293: BEGIN
294:
295: IF p_result_rule_type = 'D' THEN

Line 329: INSERT INTO pay_formula_result_rules_f

325: SELECT pay_formula_result_rules_s.nextval
326: INTO v_form_res_rule_id
327: FROM sys.dual;
328:
329: INSERT INTO pay_formula_result_rules_f
330: (formula_result_rule_id,
331: effective_start_date,
332: effective_end_date,
333: business_group_id,