APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on DUAL

Line 128: FROM DUAL

124: fnd_global.prog_appl_id , --Program Application ID
125: fnd_global.conc_program_id , --Program Id
126: fnd_global.conc_login_id , --Program Login ID
127: 1
128: FROM DUAL
129: WHERE not exists (select 1
130: from ZX_DET_FACTOR_TEMPL_B
131: where DET_FACTOR_TEMPL_CODE = 'STCC'
132: );

Line 173: FROM DUAL

169: fnd_global.prog_appl_id , --Program Application ID
170: fnd_global.conc_program_id , --Program Id
171: fnd_global.conc_login_id , --Program Login ID
172: 1
173: FROM DUAL
174: WHERE not exists (select 1
175: from ZX_DET_FACTOR_TEMPL_B
176: where DET_FACTOR_TEMPL_CODE = 'LEASE_MGT_RATE_DET_TEMPL'
177: );

Line 273: FROM DUAL

269: fnd_global.user_id , --CREATED_BY
270: fnd_global.user_id , --LAST_UPDATED_BY
271: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
272: 1 OBJECT_VERSION_NUMBER
273: FROM DUAL
274: WHERE NOT EXISTS (SELECT 1
275: FROM ZX_DETERMINING_FACTORS_B
276: WHERE DETERMINING_FACTOR_CLASS_CODE ='PRODUCT_FISCAL_CLASS'
277: AND DETERMINING_FACTOR_CODE = 'LEASE_MGT_PROD_FISC_CLASS');

Line 335: FROM DUAL

331: fnd_global.user_id , --CREATED_BY
332: fnd_global.user_id , --LAST_UPDATED_BY
333: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
334: 1 OBJECT_VERSION_NUMBER
335: FROM DUAL
336: WHERE NOT EXISTS (SELECT 1
337: FROM ZX_DETERMINING_FACTORS_B
338: WHERE DETERMINING_FACTOR_CLASS_CODE ='PARTY_FISCAL_CLASS'
339: AND DETERMINING_FACTOR_CODE = 'LEASE_MGT_PTY_FISC_CLASS');

Line 2098: FROM DUAL

2094: srvtype.service_type_code l_service_type_code
2095: FROM
2096: ZX_TAXES_B taxes,
2097: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2098: FROM DUAL
2099: UNION
2100: SELECT 'DET_TAX_RATE' service_type_code
2101: FROM DUAL ) srvtype
2102: WHERE

Line 2101: FROM DUAL ) srvtype

2097: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2098: FROM DUAL
2099: UNION
2100: SELECT 'DET_TAX_RATE' service_type_code
2101: FROM DUAL ) srvtype
2102: WHERE
2103: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET','LOCATION')
2104: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
2105: AND EXISTS (SELECT 1

Line 2146: FROM DUAL

2142: ZX_TAXES_B taxes,
2143: zx_party_tax_profile ptp,
2144: ar_system_parameters_all sys,
2145: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2146: FROM DUAL
2147: UNION
2148: SELECT 'DET_TAX_RATE' service_type_code
2149: FROM DUAL ) srvtype
2150:

Line 2149: FROM DUAL ) srvtype

2145: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2146: FROM DUAL
2147: UNION
2148: SELECT 'DET_TAX_RATE' service_type_code
2149: FROM DUAL ) srvtype
2150:
2151: WHERE taxes.RECORD_TYPE_CODE = 'MIGRATED'
2152: AND taxes.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
2153: AND taxes.tax_type_code = 'LOCATION'