APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_INPUT_VALUES_F

Line 33: pay_input_values_f INPUT

29: ) is
30: --
31: select result.status_processing_rule_id
32: from pay_formula_result_rules_f RESULT,
33: pay_input_values_f INPUT
34: where input.element_type_id = p_element_type_id
35: and input.input_value_id = result.input_value_id
36: and result.result_rule_type = p_rule_type
37: and result.effective_start_date between p_validation_start_date

Line 1618: v_input_value_id pay_input_values_f.input_value_id%type;

1614: ) return boolean is
1615: --
1616: v_run_results_exist boolean;
1617: v_input_values_exist boolean;
1618: v_input_value_id pay_input_values_f.input_value_id%type;
1619: --
1620: cursor csr_input_values is
1621: select iv.input_value_id
1622: from pay_input_values_f iv

Line 1622: from pay_input_values_f iv

1618: v_input_value_id pay_input_values_f.input_value_id%type;
1619: --
1620: cursor csr_input_values is
1621: select iv.input_value_id
1622: from pay_input_values_f iv
1623: where iv.element_type_id = p_element_type_id;
1624:
1625: cursor csr_run_result_values (p_input_value_id NUMBER) is
1626: select 1

Line 1825: pay_input_values_f IV

1821: --
1822: cursor csr_pay_basis is
1823: select 1
1824: from per_pay_bases BASIS,
1825: pay_input_values_f IV
1826: where iv.input_value_id = basis.input_value_id
1827: and iv.element_type_id = p_element_type_id;
1828: --
1829: begin

Line 2288: pay_input_values_f INPUT,

2284: --
2285: select 1
2286: from pay_status_processing_rules_f STATUS,
2287: pay_formula_result_rules_f RESULT,
2288: pay_input_values_f INPUT,
2289: pay_element_types_f ELEMENT
2290: where status.status_processing_rule_id = result.status_processing_rule_id
2291: and result.input_value_id = input.input_value_id
2292: and input.element_type_id = element.element_type_id

Line 2348: pay_input_values_f INPUT,

2344: --
2345: select 1
2346: from pay_status_processing_rules_f STATUS,
2347: pay_formula_result_rules_f RESULT,
2348: pay_input_values_f INPUT,
2349: pay_element_types_f ELEMENT
2350: where result.input_value_id = input.input_value_id
2351: and status.element_type_id = element.element_type_id
2352: and result.status_processing_rule_id= status.status_processing_rule_id