DBA Data[Home] [Help]

APPS.ZX_TRL_ALLOCATIONS_PKG dependencies on ZX_SCO_STATUS

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;

Line 1662: FROM zx_sco_status

1658: BEGIN
1659:
1660: select tax_status_id
1661: INTO l_status_id
1662: FROM zx_sco_status
1663: WHERE tax_regime_code = p_tax_regime_code
1664: AND tax = p_tax
1665: AND tax_status_code = p_tax_status_code ;
1666: