APPS.PAY_IN_UTILS dependencies on PAY_FORMULA_RESULT_RULES_F

Line 1750: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;

1746: IS
1747:
1748: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
1749: v_form_res_rule_id NUMBER;
1750: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
1751: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1752: l_procedure CONSTANT VARCHAR2(100):= g_package||'ins_form_res_rule';
1753: l_message VARCHAR2(1000);
1754:

Line 1787: INSERT INTO pay_formula_result_rules_f

1783: INTO v_form_res_rule_id
1784: FROM sys.dual;
1785:
1786: set_location(g_debug,l_procedure,50);
1787: INSERT INTO pay_formula_result_rules_f
1788: (formula_result_rule_id,
1789: effective_start_date,
1790: effective_end_date,
1791: business_group_id,

Line 1868: FROM pay_formula_result_rules_f

1864: IS
1865: SELECT ROWID
1866: ,formula_result_rule_id
1867: ,effective_start_date
1868: FROM pay_formula_result_rules_f
1869: WHERE status_processing_rule_id = p_status_rule_id
1870: AND p_effective_date BETWEEN effective_start_date
1871: AND effective_end_date;
1872: