APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 1564: pay_status_processing_rules_f SPR

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
1568: and spr.element_type_id <> p_element_type_id

Line 1768: from pay_status_processing_rules_f

1764: v_element_type_id number;
1765: --
1766: cursor csr_source_element is
1767: select element_type_id
1768: from pay_status_processing_rules_f
1769: where element_type_id = v_element_type_id
1770: and status_processing_rule_id = v_status_processing_rule_id;
1771: --
1772: begin

Line 2286: from pay_status_processing_rules_f STATUS,

2282: and which have a lower priority than the parameter
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

Line 2346: from pay_status_processing_rules_f STATUS,

2342: priority higher than the parameter priority
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