DBA Data[Home] [Help]

APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_FORMULA_RESULT_RULES_F

Line 32: from pay_formula_result_rules_f RESULT,

28: p_rule_type varchar2
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

Line 1563: from pay_formula_result_rules_f FRR,

1559: v_stop_entry_rules boolean;
1560: --
1561: cursor csr_stop_entry_rules is
1562: select null
1563: from pay_formula_result_rules_f FRR,
1564: pay_status_processing_rules_f SPR
1565: where p_element_type_id = frr.element_type_id
1566: and frr.result_rule_type = 'S'
1567: and spr.STATUS_PROCESSING_RULE_ID = frr.STATUS_PROCESSING_RULE_ID

Line 2287: pay_formula_result_rules_f RESULT,

2283: priority (not allowed) */
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

Line 2347: pay_formula_result_rules_f RESULT,

2343: (not allowed) */
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