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 409: INSERT INTO ZX_STATUS_B_TMP

405: FND_FILE.LOG,
406: 'Creating STANDARD Tax Status for Tax: '||l_tax||'.'
407: );
408:
409: INSERT INTO ZX_STATUS_B_TMP
410: (
411: TAX_STATUS_ID,
412: TAX_STATUS_CODE,
413: CONTENT_OWNER_ID,

Line 453: ZX_STATUS_B_S.NEXTVAL, --TAX_STATUS_ID

449: OBJECT_VERSION_NUMBER
450: )
451: VALUES
452: (
453: ZX_STATUS_B_S.NEXTVAL, --TAX_STATUS_ID
454: 'STANDARD', --TAX_STATUS_CODE
455: -99, --CONTENT_OWNER_ID
456: G_RECORD_EFFECTIVE_START,--EFFECTIVE_FROM
457: NULL, --EFFECTIVE_TO

Line 528: FROM ZX_STATUS_B zsb,

524: fnd_global.user_id , -- LAST_UPDATED_BY
525: SYSDATE , -- LAST_UPDATE_DATE
526: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
527: zsb.tax_status_id
528: FROM ZX_STATUS_B zsb,
529: FND_LANGUAGES fl
530: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
531: AND zsb.TAX_REGIME_CODE = p_tax_regime_code
532: AND zsb.CONTENT_OWNER_ID = -99