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 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 681: FROM zx_accounts za, zx_rates_b rates

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

Line 1130: FROM zx_rates_b zrb

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

Line 1136: FROM zx_rates_b zrb

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