DBA Data[Home] [Help]

APPS.JG_ZZ_JGZZALRL_PKG dependencies on ZX_STATUS_B

Line 79: l_tax_status_code ZX_STATUS_B.tax_status_code%Type := Null;

75: Return l_vat_tran_type;
76: End get_vat_tran_type;
77:
78: Function get_tax_status_code Return Varchar2 Is
79: l_tax_status_code ZX_STATUS_B.tax_status_code%Type := Null;
80: Begin
81: Select tax_status_code
82: Into l_tax_status_code
83: From ZX_STATUS_B

Line 83: From ZX_STATUS_B

79: l_tax_status_code ZX_STATUS_B.tax_status_code%Type := Null;
80: Begin
81: Select tax_status_code
82: Into l_tax_status_code
83: From ZX_STATUS_B
84: Where tax = nvl(p_tax_code,tax)
85: And tax_regime_code = nvl(p_vat_regime,tax_regime_code)
86: And tax_status_id = p_tax_status;
87: