APPS.PAY_ELEMENT_TYPES_PKG dependencies on PAY_STATUS_PROCESSING_RULES_F

Line 1569: pay_status_processing_rules_f SPR

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

Line 1801: from pay_status_processing_rules_f

1797: v_element_type_id number;
1798: --
1799: cursor csr_source_element is
1800: select element_type_id
1801: from pay_status_processing_rules_f
1802: where element_type_id = v_element_type_id
1803: and status_processing_rule_id = v_status_processing_rule_id;
1804: --
1805: begin

Line 2319: from pay_status_processing_rules_f STATUS,

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

Line 2379: from pay_status_processing_rules_f STATUS,

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