APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_STATUS_B

Line 54: FROM ZX_STATUS_B

50: b_content_owner_id NUMBER,
51: b_tax_status_code VARCHAR2
52: ) IS
53: SELECT 'Y'
54: FROM ZX_STATUS_B
55: WHERE TAX_REGIME_CODE = b_tax_regime_code
56: AND TAX = b_tax
57: AND CONTENT_OWNER_ID = b_content_owner_id
58: AND TAX_STATUS_CODE = b_tax_status_code;

Line 392: INSERT INTO ZX_STATUS_B_TMP

388: 'Creating STANDARD Status for Tax: '||l_tax||'.'
389: );
390:
391:
392: INSERT INTO ZX_STATUS_B_TMP
393: (
394: TAX_STATUS_ID,
395: TAX_STATUS_CODE,
396: CONTENT_OWNER_ID,

Line 436: ZX_STATUS_B_S.NEXTVAL, --TAX_STATUS_ID

432: OBJECT_VERSION_NUMBER
433: )
434: VALUES
435: (
436: ZX_STATUS_B_S.NEXTVAL, --TAX_STATUS_ID
437: 'STANDARD', --TAX_STATUS_CODE
438: -99, --CONTENT_OWNER_ID
439: G_RECORD_EFFECTIVE_START,--EFFECTIVE_FROM
440: NULL, --EFFECTIVE_TO

Line 499: FROM ZX_STATUS_B zsb,

495: fnd_global.user_id , -- LAST_UPDATED_BY
496: SYSDATE , -- LAST_UPDATE_DATE
497: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
498: zsb.tax_status_id
499: FROM ZX_STATUS_B zsb,
500: FND_LANGUAGES fl
501: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
502: AND zsb.TAX_REGIME_CODE = p_tax_regime_code
503: AND zsb.CONTENT_OWNER_ID = -99