APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_PROCESS_RESULTS

Line 9721: | This routine inserts data into ZX_RULES_B,_TL,ZX_PROCESS_RESULTS |

9717: | PROCEDURE |
9718: | create_rules |
9719: | |
9720: | DESCRIPTION |
9721: | This routine inserts data into ZX_RULES_B,_TL,ZX_PROCESS_RESULTS |
9722: | Based on AP recovery rules and associated rates. |
9723: | |
9724: | SCOPE - PUBLIC |
9725: | |

Line 10029: INSERT INTO ZX_PROCESS_RESULTS

10025:
10026: IF L_MULTI_ORG_FLAG = 'Y'
10027: THEN
10028:
10029: INSERT INTO ZX_PROCESS_RESULTS
10030: (
10031: CONDITION_GROUP_CODE ,
10032: PRIORITY ,
10033: RESULT_TYPE_CODE ,

Line 10091: zx_process_results_s.nextval ,--RESULT_ID

10087: 'N' ,--ALLOW_EXEMPTIONS_FLAG
10088: 'N' ,--ALLOW_EXCEPTIONS_FLAG
10089: 'MIGRATED' ,--RECORD_TYPE_CODE
10090: NULL ,--RESULT_API
10091: zx_process_results_s.nextval ,--RESULT_ID
10092: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
10093: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
10094: TAX_RULE_ID ,--TAX_RULE_ID
10095: fnd_global.user_id ,

Line 10175: AND not exists (select 1 from zx_process_results

10171: WHERE
10172: TEMP_GROUPS.RULE_ID = AP_RULES.RULE_ID
10173: AND TEMP_GROUPS.RATE_ID = AP_RATES.RATE_ID
10174: )
10175: AND not exists (select 1 from zx_process_results
10176: where tax_rule_id = zx_rules.tax_rule_id
10177: and condition_group_code = groups.condition_group_code
10178: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
10179: )

Line 10185: INSERT INTO ZX_PROCESS_RESULTS

10181: );
10182:
10183: ELSE
10184:
10185: INSERT INTO ZX_PROCESS_RESULTS
10186: (
10187: CONDITION_GROUP_CODE ,
10188: PRIORITY ,
10189: RESULT_TYPE_CODE ,

Line 10247: zx_process_results_s.nextval ,--RESULT_ID

10243: 'N' ,--ALLOW_EXEMPTIONS_FLAG
10244: 'N' ,--ALLOW_EXCEPTIONS_FLAG
10245: 'MIGRATED' ,--RECORD_TYPE_CODE
10246: NULL ,--RESULT_API
10247: zx_process_results_s.nextval ,--RESULT_ID
10248: CONTENT_OWNER_ID ,--CONTENT_OWNER_ID
10249: CONDITION_GROUP_ID ,--CONDITION_GROUP_ID
10250: TAX_RULE_ID ,--TAX_RULE_ID
10251: fnd_global.user_id ,

Line 10332: AND not exists (select 1 from zx_process_results

10328: WHERE
10329: TEMP_GROUPS.RULE_ID = AP_RULES.RULE_ID
10330: AND TEMP_GROUPS.RATE_ID = AP_RATES.RATE_ID
10331: )
10332: AND not exists (select 1 from zx_process_results
10333: where tax_rule_id = zx_rules.tax_rule_id
10334: and condition_group_code = groups.condition_group_code
10335: and alphanumeric_result = 'STANDARD-' || AP_RATES.RECOVERY_RATE
10336: )