APPS.PAY_IN_UTILS dependencies on PAY_FORMULA_RESULT_RULES_F

Line 1735: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;

1731: IS
1732:
1733: c_end_of_time CONSTANT DATE := TO_DATE('31/12/4712','DD/MM/YYYY');
1734: v_form_res_rule_id NUMBER;
1735: l_input_value_id pay_formula_result_rules_f.input_value_id%TYPE;
1736: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1737: l_procedure CONSTANT VARCHAR2(100):= g_package||'ins_form_res_rule';
1738: l_message VARCHAR2(1000);
1739:

Line 1772: INSERT INTO pay_formula_result_rules_f

1768: INTO v_form_res_rule_id
1769: FROM sys.dual;
1770:
1771: set_location(g_debug,l_procedure,50);
1772: INSERT INTO pay_formula_result_rules_f
1773: (formula_result_rule_id,
1774: effective_start_date,
1775: effective_end_date,
1776: business_group_id,

Line 1853: FROM pay_formula_result_rules_f

1849: IS
1850: SELECT ROWID
1851: ,formula_result_rule_id
1852: ,effective_start_date
1853: FROM pay_formula_result_rules_f
1854: WHERE status_processing_rule_id = p_status_rule_id
1855: AND p_effective_date BETWEEN effective_start_date
1856: AND effective_end_date;
1857: