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 1623: v_input_value_id pay_input_values_f.input_value_id%type;

1619: ) return boolean is
1620: --
1621: v_run_results_exist boolean;
1622: v_input_values_exist boolean;
1623: v_input_value_id pay_input_values_f.input_value_id%type;
1624: --
1625: cursor csr_input_values is
1626: select iv.input_value_id
1627: from pay_input_values_f iv

Line 1627: from pay_input_values_f iv

1623: v_input_value_id pay_input_values_f.input_value_id%type;
1624: --
1625: cursor csr_input_values is
1626: select iv.input_value_id
1627: from pay_input_values_f iv
1628: where iv.element_type_id = p_element_type_id;
1629:
1630: cursor csr_run_result_values (p_input_value_id NUMBER) is
1631: select 1

Line 1858: pay_input_values_f IV

1854: --
1855: cursor csr_pay_basis is
1856: select 1
1857: from per_pay_bases BASIS,
1858: pay_input_values_f IV
1859: where iv.input_value_id = basis.input_value_id
1860: and iv.element_type_id = p_element_type_id;
1861: --
1862: begin

Line 2321: pay_input_values_f INPUT,

2317: --
2318: select 1
2319: from pay_status_processing_rules_f STATUS,
2320: pay_formula_result_rules_f RESULT,
2321: pay_input_values_f INPUT,
2322: pay_element_types_f ELEMENT
2323: where status.status_processing_rule_id = result.status_processing_rule_id
2324: and result.input_value_id = input.input_value_id
2325: and input.element_type_id = element.element_type_id

Line 2381: pay_input_values_f INPUT,

2377: --
2378: select 1
2379: from pay_status_processing_rules_f STATUS,
2380: pay_formula_result_rules_f RESULT,
2381: pay_input_values_f INPUT,
2382: pay_element_types_f ELEMENT
2383: where result.input_value_id = input.input_value_id
2384: and status.element_type_id = element.element_type_id
2385: and result.status_processing_rule_id= status.status_processing_rule_id