APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_ACCOUNTS

Line 2602: FROM zx_accounts

2598: CURSOR get_rec_nrec_ccid_cur(c_tax_account_entity_id NUMBER,
2599: c_tax_account_entity_code VARCHAR2,
2600: c_org_id NUMBER) IS
2601: SELECT interim_tax_ccid, tax_account_ccid, non_rec_account_ccid
2602: FROM zx_accounts
2603: WHERE TAX_ACCOUNT_ENTITY_ID = c_tax_account_entity_id
2604: AND tax_account_entity_code = c_tax_account_entity_code
2605: AND internal_organization_id = c_org_id;
2606:

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

2654: --
2655: -- - Tax liability account should always be returned as NULL, for both
2656: -- Recoverable and non-recoverable distributions
2657: -- - For recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2658: -- obtained by joining to ZX_ACCOUNTS using Receovery Rate Id first.
2659: -- If account is not found using recovery rate id, then the account should
2660: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery
2661: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2662: -- otherwise return tax_account_ccid.

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

2656: -- Recoverable and non-recoverable distributions
2657: -- - For recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2658: -- obtained by joining to ZX_ACCOUNTS using Receovery Rate Id first.
2659: -- If account is not found using recovery rate id, then the account should
2660: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery
2661: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2662: -- otherwise return tax_account_ccid.
2663: -- - For non-recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2664: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned

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

2660: -- be obtained from ZX_ACCOUNTS using tax_rate_id. If default reocovery
2661: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2662: -- otherwise return tax_account_ccid.
2663: -- - For non-recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2664: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned
2665: -- should be the Non-Recoverable or Expense Account from zx_accounts. If
2666: -- account is not found usnig this logic then the API should return the
2667: -- Item/Expense Account passed in (p_revenue_expense_ccid). (We do not make
2668: -- use of default recovery settlement option code in this case)

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

2661: -- settlement option code is DEFERRED, then return the interim_tax_ccid
2662: -- otherwise return tax_account_ccid.
2663: -- - For non-recoverable tax distributions, the REC_NREC_ACCOUNT_CCID should be
2664: -- obtained from ZX_ACCOUNTS using Tax Rate Id first. The account returned
2665: -- should be the Non-Recoverable or Expense Account from zx_accounts. If
2666: -- account is not found usnig this logic then the API should return the
2667: -- Item/Expense Account passed in (p_revenue_expense_ccid). (We do not make
2668: -- use of default recovery settlement option code in this case)
2669: --

Line 3414: from zx_accounts

3410: c_ledger_id number) is
3411: select tax_account_ccid, interim_tax_ccid, adj_ccid, edisc_ccid,
3412: unedisc_ccid, finchrg_ccid, adj_non_rec_tax_ccid, edisc_non_rec_tax_ccid,
3413: unedisc_non_rec_tax_ccid, finchrg_non_rec_tax_ccid
3414: from zx_accounts
3415: where TAX_ACCOUNT_ENTITY_ID = c_tax_account_entity_id
3416: and tax_account_entity_code = c_tax_account_entity_code
3417: and internal_organization_id = c_org_id
3418: and ledger_id = c_ledger_id;

Line 5977: from zx_accounts

5973: Cursor get_rec_ccid_cur(c_tax_account_entity_id number,
5974: c_ledger_id number,
5975: c_internal_org_id number) is
5976: select tax_account_ccid
5977: from zx_accounts
5978: where TAX_ACCOUNT_ENTITY_ID = c_tax_account_entity_id
5979: and TAX_ACCOUNT_ENTITY_CODE = 'RATES'
5980: and ledger_id = c_ledger_id
5981: and internal_organization_id = c_internal_org_id;