APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on ZX_TAXES_B_S

Line 1917: ZX_TAXES_B_S.NEXTVAL ,

1913: L_PARENT_GEOGRAPHY_TYPE ,
1914: L_PARENT_GEOGRAPHY_ID ,
1915: L_ALLOW_MASS_CREATE_FLAG ,
1916: L_APPLIED_AMT_HANDLING_FLAG ,
1917: ZX_TAXES_B_S.NEXTVAL ,
1918: L_CONTENT_OWNER_ID ,
1919: L_REP_TAX_AUTHORITY_ID ,
1920: L_COLL_TAX_AUTHORITY_ID ,
1921: L_THRSHLD_CHK_TMPLT_CODE ,

Line 1956: ZX_TAXES_B_S.NEXTVAL ,

1952: LAST_UPDATE_LOGIN
1953: )
1954: VALUES
1955: (
1956: ZX_TAXES_B_S.NEXTVAL ,
1957: USERENV('LANG') ,
1958: USERENV('LANG') ,
1959: 'LOCATION' ,
1960: L_CREATED_BY ,

Line 2074: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,

2070: WHERE country_code = asp.default_country
2071: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2072: 'N' L_ALLOW_MASS_CREATE_FLAG,
2073: 'P' L_APPLIED_AMT_HANDLING_FLAG,
2074: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,
2075: ptp.party_tax_profile_id L_CONTENT_OWNER_ID,
2076: NULL L_REP_TAX_AUTHORITY_ID,
2077: NULL L_COLL_TAX_AUTHORITY_ID,
2078: NULL L_THRSHLD_CHK_TMPLT_CODE,

Line 2331: ZX_TAXES_B_S.NEXTVAL ,

2327: L_PARENT_GEOGRAPHY_TYPE ,
2328: L_PARENT_GEOGRAPHY_ID ,
2329: L_ALLOW_MASS_CREATE_FLAG ,
2330: L_APPLIED_AMT_HANDLING_FLAG ,
2331: ZX_TAXES_B_S.NEXTVAL ,
2332: L_CONTENT_OWNER_ID ,
2333: L_REP_TAX_AUTHORITY_ID ,
2334: L_COLL_TAX_AUTHORITY_ID ,
2335: L_THRSHLD_CHK_TMPLT_CODE ,

Line 2370: ZX_TAXES_B_S.NEXTVAL ,

2366: LAST_UPDATE_LOGIN
2367: )
2368: VALUES
2369: (
2370: ZX_TAXES_B_S.NEXTVAL ,
2371: USERENV('LANG') ,
2372: USERENV('LANG') ,
2373: 'LOCATION' ,
2374: L_CREATED_BY ,

Line 2488: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,

2484: WHERE country_code = asp.default_country
2485: AND rownum = 1) L_PARENT_GEOGRAPHY_ID,
2486: 'N' L_ALLOW_MASS_CREATE_FLAG,
2487: 'P' L_APPLIED_AMT_HANDLING_FLAG,
2488: --ZX_TAXES_B_S.NEXTVAL L_TAX_ID,
2489: ptp.party_tax_profile_id L_CONTENT_OWNER_ID,
2490: NULL L_REP_TAX_AUTHORITY_ID,
2491: NULL L_COLL_TAX_AUTHORITY_ID,
2492: NULL L_THRSHLD_CHK_TMPLT_CODE,

Line 6481: zx_taxes_b_s.nextval , -- TAX_ID

6477: NULL , -- PARENT_GEOGRAPHY_TYPE
6478: NULL , -- PARENT_GEOGRAPHY_ID
6479: 'Y' , -- ALLOW_MASS_CREATE_FLAG /*Bug fix 552412*/
6480: 'P' , -- APPLIED_AMT_HANDLING_FLAG
6481: zx_taxes_b_s.nextval , -- TAX_ID
6482: -99 , -- CONTENT_OWNER_ID
6483: NULL , -- REP_TAX_AUTHORITY_ID
6484: NULL , -- COLL_TAX_AUTHORITY_ID
6485: NULL , -- THRSHLD_CHK_TMPLT_CODE

Line 6542: ZX_TAXES_B_S.NEXTVAL

6538: fnd_global.user_id,
6539: SYSDATE,
6540: fnd_global.user_id,
6541: fnd_global.conc_login_id,
6542: ZX_TAXES_B_S.NEXTVAL
6543: )*/
6544: SELECT 1 FROM DUAL;
6545:
6546: EXCEPTION

Line 7622: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7618: NULL ,--PARENT_GEOGRAPHY_TYPE --YK:8/30/2004: Can be populated for US Sales Tax
7619: NULL ,--PARENT_GEOGRAPHY_ID --YK:8/30/2004: Can be populated for US Sales Tax
7620: 'N' ,--ALLOW_MASS_CREATE_FLAG
7621: 'P' ,--APPLIED_AMT_HANDLING_FLAG --Bug 5232502
7622: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7623: L_CONTENT_OWNER_ID ,
7624: NULL ,--REP_TAX_AUTHORITY_ID
7625: NULL ,--COLL_TAX_AUTHORITY_ID
7626: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 7975: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID

7971: NULL ,--PARENT_GEOGRAPHY_TYPE --YK:8/30/2004: Can be populated for US Sales Tax
7972: NULL ,--PARENT_GEOGRAPHY_ID --YK:8/30/2004: Can be populated for US Sales Tax
7973: 'N' ,--ALLOW_MASS_CREATE_FLAG
7974: 'P' ,--APPLIED_AMT_HANDLING_FLAG --Bug 5232502
7975: ZX_TAXES_B_S.NEXTVAL ,--TAX_ID
7976: L_CONTENT_OWNER_ID ,
7977: NULL ,--REP_TAX_AUTHORITY_ID
7978: NULL ,--COLL_TAX_AUTHORITY_ID
7979: NULL ,--THRSHLD_CHK_TMPLT_CODE

Line 9076: THEN SUBSTRB(codes.tax_code, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')

9072: FROM
9073: (
9074: SELECT
9075: CASE WHEN LENGTHB(codes.tax_code) > 30
9076: THEN SUBSTRB(codes.tax_code, 1, 24) ||ZX_MIGRATE_UTIL.GET_NEXT_SEQID('ZX_TAXES_B_S')
9077: ELSE codes.tax_code
9078: END LOOKUP_CODE,
9079: CASE WHEN LENGTHB(codes.tax_code) > 30
9080: THEN codes.tax_code