DBA Data[Home] [Help]

APPS.JA_JAINCVAT_XMLP_PKG dependencies on JAI_CMN_RG_ROUND_HDRS

Line 96: JAI_CMN_RG_ROUND_HDRS

92: SELECT
93: ROUNDED_EXCISE_EDU_CESS + ROUNDED_CVD_EDU_CESS,
94: ( EXCISE_EDU_CESS + CVD_EDU_CESS - ROUNDED_EXCISE_EDU_CESS - ROUNDED_CVD_EDU_CESS ) BAL
95: FROM
96: JAI_CMN_RG_ROUND_HDRS
97: WHERE EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
98: AND ROUNDING_ID = LN_ROUNDING_ID;
99: CURSOR CUR_RG_EXCISE IS
100: SELECT

Line 153: JAI_CMN_RG_ROUND_HDRS

149: NVL(ROUNDED_ADDITIONAL_CVD
150: ,0),
151: ( BASIC_ED + ADDITIONAL_ED + OTHER_ED ) - ( ROUNDED_BASIC_ED + ROUNDED_ADDITIONAL_ED + ROUNDED_OTHER_ED )
152: FROM
153: JAI_CMN_RG_ROUND_HDRS
154: WHERE EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
155: AND ROUNDING_ID = LN_ROUNDING_ID;
156: BEGIN
157: OPEN CUR_ROUNDING_ID;

Line 200: JAI_CMN_RG_ROUND_HDRS

196: SELECT
197: ROUNDED_SH_EXCISE_EDU_CESS + ROUNDED_SH_CVD_EDU_CESS,
198: ( SH_EXCISE_EDU_CESS + SH_CVD_EDU_CESS - ROUNDED_SH_EXCISE_EDU_CESS - ROUNDED_SH_CVD_EDU_CESS ) BAL
199: FROM
200: JAI_CMN_RG_ROUND_HDRS
201: WHERE EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
202: AND ROUNDING_ID = LN_ROUNDING_ID;
203: CURSOR CUR_RG_EXCISE IS
204: SELECT