APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_RATES_B

Line 531: FROM zx_rates_b zrb,

527: NVL(za.tax_account_ccid, za.non_rec_account_ccid)
528: -- Bug 4766614
529: -- Added NVL so that when tax_account_ccid is null
530: -- the API returns non_rec_account_ccid
531: FROM zx_rates_b zrb,
532: zx_accounts za
533: WHERE nvl(zrb.source_id, zrb.tax_rate_id) = p_tax_rate_id
534: AND za.internal_organization_id(+) = p_org_id
535: AND za.ledger_id(+) = p_ledger_id

Line 682: FROM zx_accounts za, zx_rates_b rates

678: SELECT NVL(tax_account_ccid, non_rec_account_ccid)
679: -- Bug 4766614
680: -- Added NVL so that when tax_account_ccid is null
681: -- the API returns non_rec_account_ccid
682: FROM zx_accounts za, zx_rates_b rates
683: WHERE nvl(rates.source_id, rates.tax_rate_id) = p_tax_rate_id
684: AND za.tax_account_entity_id(+) = rates.tax_rate_id
685: AND za.tax_account_entity_code(+) = 'RATES'
686: AND za.ledger_id(+) = p_ledger_id

Line 1131: FROM zx_rates_b zrb

1127: -- ***** CURSORS *****
1128: CURSOR get_tax_rate_code_cur (p_tax_rate_id NUMBER)
1129: IS
1130: SELECT zrb.tax_rate_code
1131: FROM zx_rates_b zrb
1132: WHERE zrb.tax_rate_id = p_tax_rate_id;
1133:
1134: CURSOR get_source_rate_code_cur (p_tax_rate_id NUMBER)
1135: IS

Line 1137: FROM zx_rates_b zrb

1133:
1134: CURSOR get_source_rate_code_cur (p_tax_rate_id NUMBER)
1135: IS
1136: SELECT zrb.tax_rate_code
1137: FROM zx_rates_b zrb
1138: WHERE zrb.source_id = p_tax_rate_id;
1139:
1140: -- ***** VARIABLES *****
1141: l_tax_rate_code VARCHAR2(50);