APPS.ZX_TRL_ALLOCATIONS_PKG dependencies on ZX_SCO_STATUS_B_V

Line 825: -- ZX_SCO_STATUS_B_V in place of ZX_SCO_STATUS

821: AND tax_regime_code = c_tax_regime_code
822: ORDER BY subscription_level_code;
823:
824: -- Added this cursor to fetch the data from
825: -- ZX_SCO_STATUS_B_V in place of ZX_SCO_STATUS
826: CURSOR get_tax_status_id (c_tax_regime_code VARCHAR2,
827: c_tax VARCHAR2,
828: c_tax_status_code VARCHAR2)
829: IS

Line 831: FROM zx_sco_status_b_v

827: c_tax VARCHAR2,
828: c_tax_status_code VARCHAR2)
829: IS
830: SELECT tax_status_id
831: FROM zx_sco_status_b_v
832: WHERE tax_status_code = c_tax_status_code
833: AND tax = c_tax
834: AND tax_regime_code = c_tax_regime_code
835: ORDER BY subscription_level_code;