APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_DET_FACTOR_TEMPL_B

Line 8783: INSERT INTO ZX_DET_FACTOR_TEMPL_B

8779: IF PG_DEBUG = 'Y' THEN
8780: arp_util_tax.debug('create_templates(+)');
8781: END IF;
8782:
8783: INSERT INTO ZX_DET_FACTOR_TEMPL_B
8784: (
8785: DET_FACTOR_TEMPL_CODE ,
8786: TAX_REGIME_CODE ,
8787: TEMPLATE_USAGE_CODE ,

Line 8810: zx_det_factor_templ_b_s.nextval ,

8806: 'TAX_RULES' ,
8807: 'MIGRATED' ,
8808: NULL ,
8809: NULL ,
8810: zx_det_factor_templ_b_s.nextval ,
8811: fnd_global.user_id ,
8812: SYSDATE ,
8813: fnd_global.user_id ,
8814: SYSDATE ,

Line 8823: from ZX_DET_FACTOR_TEMPL_B

8819: fnd_global.conc_login_id , --Program Login ID
8820: 1
8821: FROM DUAL
8822: WHERE not exists (select 1
8823: from ZX_DET_FACTOR_TEMPL_B
8824: where DET_FACTOR_TEMPL_CODE =
8825: 'EX Acct String Range-Party FC'
8826: );
8827:

Line 8859: ZX_DET_FACTOR_TEMPL_B B

8855: fnd_global.user_id ,
8856: fnd_global.conc_login_id
8857: FROM
8858: FND_LANGUAGES L,
8859: ZX_DET_FACTOR_TEMPL_B B
8860: WHERE
8861: L.INSTALLED_FLAG in ('I', 'B')
8862: AND RECORD_TYPE_CODE = 'MIGRATED'
8863: AND not exists

Line 8921: ZX_DET_FACTOR_TEMPL_B TEMPL

8917: 'Y' REQUIRED_FLAG ,
8918: 'MIGRATED' RECORD_TYPE_CODE ,
8919: TEMPL.DET_FACTOR_TEMPL_ID DET_FACTOR_TEMPL_ID
8920: FROM
8921: ZX_DET_FACTOR_TEMPL_B TEMPL
8922: WHERE
8923: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8924: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8925: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL

Line 8940: ZX_DET_FACTOR_TEMPL_B TEMPL

8936: 'N' REQUIRED_FLAG ,
8937: 'MIGRATED' RECORD_TYPE_CODE ,
8938: TEMPL.DET_FACTOR_TEMPL_ID DET_FACTOR_TEMPL_ID
8939: FROM
8940: ZX_DET_FACTOR_TEMPL_B TEMPL
8941: WHERE
8942: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8943: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8944: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL