APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_DET_FACTOR_TEMPL_B

Line 8761: INSERT INTO ZX_DET_FACTOR_TEMPL_B

8757: IF PG_DEBUG = 'Y' THEN
8758: arp_util_tax.debug('create_templates(+)');
8759: END IF;
8760:
8761: INSERT INTO ZX_DET_FACTOR_TEMPL_B
8762: (
8763: DET_FACTOR_TEMPL_CODE ,
8764: TAX_REGIME_CODE ,
8765: TEMPLATE_USAGE_CODE ,

Line 8788: zx_det_factor_templ_b_s.nextval ,

8784: 'TAX_RULES' ,
8785: 'MIGRATED' ,
8786: NULL ,
8787: NULL ,
8788: zx_det_factor_templ_b_s.nextval ,
8789: fnd_global.user_id ,
8790: SYSDATE ,
8791: fnd_global.user_id ,
8792: SYSDATE ,

Line 8801: from ZX_DET_FACTOR_TEMPL_B

8797: fnd_global.conc_login_id , --Program Login ID
8798: 1
8799: FROM DUAL
8800: WHERE not exists (select 1
8801: from ZX_DET_FACTOR_TEMPL_B
8802: where DET_FACTOR_TEMPL_CODE =
8803: 'EX Acct String Range-Party FC'
8804: );
8805:

Line 8837: ZX_DET_FACTOR_TEMPL_B B

8833: fnd_global.user_id ,
8834: fnd_global.conc_login_id
8835: FROM
8836: FND_LANGUAGES L,
8837: ZX_DET_FACTOR_TEMPL_B B
8838: WHERE
8839: L.INSTALLED_FLAG in ('I', 'B')
8840: AND RECORD_TYPE_CODE = 'MIGRATED'
8841: AND not exists

Line 8896: ZX_DET_FACTOR_TEMPL_B TEMPL

8892: 'Y' REQUIRED_FLAG ,
8893: 'MIGRATED' RECORD_TYPE_CODE ,
8894: TEMPL.DET_FACTOR_TEMPL_ID DET_FACTOR_TEMPL_ID
8895: FROM
8896: ZX_DET_FACTOR_TEMPL_B TEMPL
8897: WHERE
8898: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8899: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8900: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL

Line 8915: ZX_DET_FACTOR_TEMPL_B TEMPL

8911: 'N' REQUIRED_FLAG ,
8912: 'MIGRATED' RECORD_TYPE_CODE ,
8913: TEMPL.DET_FACTOR_TEMPL_ID DET_FACTOR_TEMPL_ID
8914: FROM
8915: ZX_DET_FACTOR_TEMPL_B TEMPL
8916: WHERE
8917: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8918: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8919: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL