DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_CONDITIONS

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

8966: | PROCEDURE |
8967: | create_condition_groups |
8968: | |
8969: | DESCRIPTION |
8970: | This routine inserts data into ZX_CONDITIONS,ZX_CONDITION_GROUPS_B,_TL|
8971: | Based on AP recovery rules and associated rates. |
8972: | |
8973: | SCOPE - PUBLIC |
8974: | |

Line 8997: INSERT INTO ZX_conditions

8993: IF PG_DEBUG = 'Y' THEN
8994: arp_util_tax.debug('create_condition_groups(+)');
8995: END IF;
8996:
8997: INSERT INTO ZX_conditions
8998: (
8999: DETERMINING_FACTOR_CODE ,
9000: CONDITION_GROUP_CODE ,
9001: TAX_PARAMETER_CODE ,

Line 9042: zx_conditions_s.nextval ,--CONDITION_ID

9038: DATE_VALUE ,
9039: ALPHANUMERIC_VALUE ,
9040: VALUE_LOW ,
9041: VALUE_HIGH ,
9042: zx_conditions_s.nextval ,--CONDITION_ID
9043: fnd_global.user_id ,
9044: SYSDATE ,
9045: fnd_global.user_id ,
9046: SYSDATE ,

Line 9111: (SELECT 1 FROM ZX_CONDITIONS WHERE

9107: ) ZX_COND
9108:
9109: WHERE NOT EXISTS
9110:
9111: (SELECT 1 FROM ZX_CONDITIONS WHERE
9112: DETERMINING_FACTOR_CODE = ZX_COND.DETERMINING_FACTOR_CODE
9113: AND DETERMINING_FACTOR_CLASS_CODE= ZX_COND.DETERMINING_FACTOR_CLASS_CODE
9114: AND CONDITION_GROUP_CODE = ZX_COND.CONDITION_GROUP_CODE);
9115: