APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_CONDITIONS

Line 8945: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|

8941: | PROCEDURE |
8942: | create_condition_groups |
8943: | |
8944: | DESCRIPTION |
8945: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|
8946: | Based on AP recovery rules and associated rates. |
8947: | |
8948: | SCOPE - PUBLIC |
8949: | |

Line 8972: INSERT INTO ZX_conditions

8968: IF PG_DEBUG = 'Y' THEN
8969: arp_util_tax.debug('create_condition_groups(+)');
8970: END IF;
8971:
8972: INSERT INTO ZX_conditions
8973: (
8974: DETERMINING_FACTOR_CODE ,
8975: CONDITION_GROUP_CODE ,
8976: TAX_PARAMETER_CODE ,

Line 9017: zx_conditions_s.nextval ,--CONDITION_ID

9013: DATE_VALUE ,
9014: ALPHANUMERIC_VALUE ,
9015: VALUE_LOW ,
9016: VALUE_HIGH ,
9017: zx_conditions_s.nextval ,--CONDITION_ID
9018: fnd_global.user_id ,
9019: SYSDATE ,
9020: fnd_global.user_id ,
9021: SYSDATE ,

Line 9087: (SELECT 1 FROM ZX_CONDITIONS WHERE

9083: ) ZX_COND
9084:
9085: WHERE NOT EXISTS
9086:
9087: (SELECT 1 FROM ZX_CONDITIONS WHERE
9088: DETERMINING_FACTOR_CODE = ZX_COND.DETERMINING_FACTOR_CODE
9089: AND DETERMINING_FACTOR_CLASS_CODE= ZX_COND.DETERMINING_FACTOR_CLASS_CODE
9090: AND CONDITION_GROUP_CODE = ZX_COND.CONDITION_GROUP_CODE);
9091: