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 1568: from pay_formula_result_rules_f FRR,

1564: v_stop_entry_rules boolean;
1565: --
1566: cursor csr_stop_entry_rules is
1567: select null
1568: from pay_formula_result_rules_f FRR,
1569: pay_status_processing_rules_f SPR
1570: where p_element_type_id = frr.element_type_id
1571: and frr.result_rule_type = 'S'
1572: and spr.STATUS_PROCESSING_RULE_ID = frr.STATUS_PROCESSING_RULE_ID

Line 2320: pay_formula_result_rules_f RESULT,

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

Line 2380: pay_formula_result_rules_f RESULT,

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