APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_ACCOUNTS

Line 2430: from zx_accounts

2426: Cursor get_rec_nrec_ccid_cur(c_tax_account_entity_id number,
2427: c_tax_account_entity_code VARCHAR2,
2428: c_org_id NUMBER) is
2429: select interim_tax_ccid, tax_account_ccid, non_rec_account_ccid
2430: from zx_accounts
2431: where TAX_ACCOUNT_ENTITY_ID = c_tax_account_entity_id
2432: AND tax_account_entity_code = c_tax_account_entity_code
2433: AND internal_organization_id = c_org_id;
2434:

Line 2464: -- obtained by joining to ZX_ACCOUNTS using Receovery Rate Id first.

2460: --
2461: -- - Tax liability account should always be returned as NULL, for both
2462: -- Recoverable and non-recoverable distributions
2463: -- - For recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2464: -- obtained by joining to ZX_ACCOUNTS using Receovery Rate Id first.
2465: -- If account is not found using recovery rate id, then the account should
2466: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery
2467: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2468: -- otherwise return tax_account_ccid.

Line 2466: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery

2462: -- Recoverable and non-recoverable distributions
2463: -- - For recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2464: -- obtained by joining to ZX_ACCOUNTS using Receovery Rate Id first.
2465: -- If account is not found using recovery rate id, then the account should
2466: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery
2467: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2468: -- otherwise return tax_account_ccid.
2469: -- - For non-recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2470: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned

Line 2470: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned

2466: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery
2467: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2468: -- otherwise return tax_account_ccid.
2469: -- - For non-recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2470: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned
2471: -- should be the Non-Recoverable or Expense Account from zx_accounts. If
2472: -- account is not found usnig this logic then the API should return the
2473: -- Item/Expense Account passed in (p_revenue_expense_ccid). (We do not make
2474: -- use of default recovery settlement option code in this case)

Line 2471: -- should be the Non-Recoverable or Expense Account from zx_accounts. If

2467: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2468: -- otherwise return tax_account_ccid.
2469: -- - For non-recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2470: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned
2471: -- should be the Non-Recoverable or Expense Account from zx_accounts. If
2472: -- account is not found usnig this logic then the API should return the
2473: -- Item/Expense Account passed in (p_revenue_expense_ccid). (We do not make
2474: -- use of default recovery settlement option code in this case)
2475: --

Line 3224: from zx_accounts

3220: c_ledger_id number) is
3221: select tax_account_ccid, interim_tax_ccid, adj_ccid, edisc_ccid,
3222: unedisc_ccid, finchrg_ccid, adj_non_rec_tax_ccid, edisc_non_rec_tax_ccid,
3223: unedisc_non_rec_tax_ccid, finchrg_non_rec_tax_ccid
3224: from zx_accounts
3225: where TAX_ACCOUNT_ENTITY_ID = c_tax_account_entity_id
3226: and tax_account_entity_code = c_tax_account_entity_code
3227: and internal_organization_id = c_org_id
3228: and ledger_id = c_ledger_id;

Line 5691: from zx_accounts

5687: Cursor get_rec_ccid_cur(c_tax_account_entity_id number,
5688: c_ledger_id number,
5689: c_internal_org_id number) is
5690: select tax_account_ccid
5691: from zx_accounts
5692: where TAX_ACCOUNT_ENTITY_ID = c_tax_account_entity_id
5693: and TAX_ACCOUNT_ENTITY_CODE = 'RATES'
5694: and ledger_id = c_ledger_id
5695: and internal_organization_id = c_internal_org_id;