APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on DUAL

Line 126: FROM DUAL

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

Line 171: FROM DUAL

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

Line 271: FROM DUAL

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

Line 333: FROM DUAL

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

Line 1932: FROM DUAL

1928: srvtype.service_type_code l_service_type_code
1929: FROM
1930: ZX_TAXES_B taxes,
1931: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1932: FROM DUAL
1933: UNION
1934: SELECT 'DET_TAX_RATE' service_type_code
1935: FROM DUAL ) srvtype
1936: WHERE

Line 1935: FROM DUAL ) srvtype

1931: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1932: FROM DUAL
1933: UNION
1934: SELECT 'DET_TAX_RATE' service_type_code
1935: FROM DUAL ) srvtype
1936: WHERE
1937: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET','LOCATION')
1938: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1939: AND EXISTS (SELECT 1

Line 1980: FROM DUAL

1976: ZX_TAXES_B taxes,
1977: zx_party_tax_profile ptp,
1978: ar_system_parameters_all sys,
1979: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1980: FROM DUAL
1981: UNION
1982: SELECT 'DET_TAX_RATE' service_type_code
1983: FROM DUAL ) srvtype
1984:

Line 1983: FROM DUAL ) srvtype

1979: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1980: FROM DUAL
1981: UNION
1982: SELECT 'DET_TAX_RATE' service_type_code
1983: FROM DUAL ) srvtype
1984:
1985: WHERE taxes.RECORD_TYPE_CODE = 'MIGRATED'
1986: AND taxes.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
1987: AND taxes.tax_type_code = 'LOCATION'