APPS.ZX_UTIL_PKG dependencies on ZX_ACCOUNTS

Line 77: INSERT INTO ZX_ACCOUNTS

73:
74: IF (p_tax_account_entity_code = 'TAXES')
75: THEN
76:
77: INSERT INTO ZX_ACCOUNTS
78: (
79: TAX_ACCOUNT_ID,
80: OBJECT_VERSION_NUMBER,
81: TAX_ACCOUNT_ENTITY_CODE,

Line 104: zx_accounts_s.nextval,

100: LAST_UPDATE_DATE,
101: LAST_UPDATE_LOGIN
102: )
103: SELECT
104: zx_accounts_s.nextval,
105: 1,
106: 'JURISDICTION',
107: zjb.TAX_JURISDICTION_ID,
108: za.LEDGER_ID,

Line 127: FROM ZX_ACCOUNTS za,

123: za.CREATION_DATE,
124: za.LAST_UPDATED_BY,
125: za.LAST_UPDATE_DATE,
126: za.LAST_UPDATE_LOGIN
127: FROM ZX_ACCOUNTS za,
128: ZX_TAXES_B ztb,
129: ZX_JURISDICTIONS_B zjb
130: WHERE za.TAX_ACCOUNT_ENTITY_CODE = p_tax_account_entity_code
131: AND za.TAX_ACCOUNT_ENTITY_ID = p_tax_account_entity_id

Line 136: FROM ZX_ACCOUNTS juris_za

132: AND ztb.TAX_ID = za.TAX_ACCOUNT_ENTITY_ID
133: AND zjb.TAX_REGIME_CODE = ztb.TAX_REGIME_CODE
134: AND zjb.TAX = ztb.TAX
135: AND NOT EXISTS (SELECT NULL
136: FROM ZX_ACCOUNTS juris_za
137: WHERE juris_za.TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
138: AND juris_za.TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID
139: AND juris_za.LEDGER_ID = za.LEDGER_ID
140: AND juris_za.INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);

Line 142: INSERT INTO ZX_ACCOUNTS

138: AND juris_za.TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID
139: AND juris_za.LEDGER_ID = za.LEDGER_ID
140: AND juris_za.INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);
141:
142: INSERT INTO ZX_ACCOUNTS
143: (
144: TAX_ACCOUNT_ID,
145: OBJECT_VERSION_NUMBER,
146: TAX_ACCOUNT_ENTITY_CODE,

Line 169: zx_accounts_s.nextval,

165: LAST_UPDATE_DATE,
166: LAST_UPDATE_LOGIN
167: )
168: SELECT
169: zx_accounts_s.nextval,
170: 1,
171: 'RATES',
172: zrb.TAX_RATE_ID,
173: za.LEDGER_ID,

Line 192: FROM ZX_ACCOUNTS za,

188: za.CREATION_DATE,
189: za.LAST_UPDATED_BY,
190: za.LAST_UPDATE_DATE,
191: za.LAST_UPDATE_LOGIN
192: FROM ZX_ACCOUNTS za,
193: ZX_TAXES_B ztb,
194: ZX_RATES_B zrb
195: WHERE za.TAX_ACCOUNT_ENTITY_CODE = p_tax_account_entity_code
196: AND za.TAX_ACCOUNT_ENTITY_ID = p_tax_account_entity_id

Line 201: FROM ZX_ACCOUNTS rates_za

197: AND ztb.TAX_ID = za.TAX_ACCOUNT_ENTITY_ID
198: AND zrb.TAX_REGIME_CODE = ztb.TAX_REGIME_CODE
199: AND zrb.TAX = ztb.TAX
200: AND NOT EXISTS (SELECT NULL
201: FROM ZX_ACCOUNTS rates_za
202: WHERE rates_za.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
203: AND rates_za.TAX_ACCOUNT_ENTITY_ID = zrb.TAX_RATE_ID
204: AND rates_za.LEDGER_ID = za.LEDGER_ID
205: AND rates_za.INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);

Line 212: INSERT INTO ZX_ACCOUNTS

208:
209: IF (p_tax_account_entity_code = 'JURISDICTION')
210: THEN
211:
212: INSERT INTO ZX_ACCOUNTS
213: (
214: TAX_ACCOUNT_ID,
215: OBJECT_VERSION_NUMBER,
216: TAX_ACCOUNT_ENTITY_CODE,

Line 239: zx_accounts_s.nextval,

235: LAST_UPDATE_DATE,
236: LAST_UPDATE_LOGIN
237: )
238: SELECT
239: zx_accounts_s.nextval,
240: 1,
241: 'RATES',
242: zrb.TAX_RATE_ID,
243: za.LEDGER_ID,

Line 262: FROM ZX_ACCOUNTS za,

258: za.CREATION_DATE,
259: za.LAST_UPDATED_BY,
260: za.LAST_UPDATE_DATE,
261: za.LAST_UPDATE_LOGIN
262: FROM ZX_ACCOUNTS za,
263: ZX_JURISDICTIONS_B zjb,
264: ZX_RATES_B zrb
265: WHERE za.TAX_ACCOUNT_ENTITY_CODE = p_tax_account_entity_code
266: AND za.TAX_ACCOUNT_ENTITY_ID = p_tax_account_entity_id

Line 272: FROM ZX_ACCOUNTS rates_za

268: AND zjb.TAX_JURISDICTION_ID = za.TAX_ACCOUNT_ENTITY_ID
269: AND zrb.TAX_REGIME_CODE = zjb.TAX_REGIME_CODE
270: AND zrb.TAX = zjb.TAX
271: AND NOT EXISTS (SELECT NULL
272: FROM ZX_ACCOUNTS rates_za
273: WHERE rates_za.TAX_ACCOUNT_ENTITY_CODE = 'RATES'
274: AND rates_za.TAX_ACCOUNT_ENTITY_ID = zrb.TAX_RATE_ID
275: AND rates_za.LEDGER_ID = za.LEDGER_ID
276: AND rates_za.INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);