APPS.JA_JAINVAR_XMLP_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 31: JAI_CMN_RG_23AC_II_TRXS A

27: CURSOR FOLIO_NUM1(V_INVENTORY_ITEM_ID IN NUMBER) IS
28: SELECT
29: TO_CHAR(A.INVENTORY_ITEM_ID) || '/' || TO_CHAR(A.SLNO)
30: FROM
31: JAI_CMN_RG_23AC_II_TRXS A
32: WHERE A.EXCISE_INVOICE_NO = EXCISE_INVOICE_NO
33: AND A.INVENTORY_ITEM_ID = V_INVENTORY_ITEM_ID
34: AND A.DR_BASIC_ED = CF_4;
35: CURSOR FOLIO_NUM2(V_INVENTORY_ITEM_ID IN NUMBER) IS

Line 112: JAI_CMN_RG_23AC_II_TRXS A

108: CURSOR EXCISE_AMOUNT1 IS
109: SELECT
110: DR_ADDITIONAL_ED
111: FROM
112: JAI_CMN_RG_23AC_II_TRXS A
113: WHERE A.EXCISE_INVOICE_NO = CF_5FORMULA.EXCISE_INVOICE_NO
114: AND A.INVENTORY_ITEM_ID = CF_5FORMULA.INVENTORY_ITEM_ID;
115: CURSOR EXCISE_AMOUNT2 IS
116: SELECT

Line 146: JAI_CMN_RG_23AC_II_TRXS A

142: CURSOR EXCISE_AMOUNT1 IS
143: SELECT
144: DR_OTHER_ED
145: FROM
146: JAI_CMN_RG_23AC_II_TRXS A
147: WHERE A.EXCISE_INVOICE_NO = CF_6FORMULA.EXCISE_INVOICE_NO
148: AND A.INVENTORY_ITEM_ID = CF_6FORMULA.INVENTORY_ITEM_ID;
149: CURSOR EXCISE_AMOUNT2 IS
150: SELECT

Line 417: JAI_CMN_RG_23AC_II_TRXS A

413: CURSOR SLNO1(V_INVENTORY_ITEM_ID IN NUMBER) IS
414: SELECT
415: A.SLNO
416: FROM
417: JAI_CMN_RG_23AC_II_TRXS A
418: WHERE A.EXCISE_INVOICE_NO = CF_17FORMULA.EXCISE_INVOICE_NO
419: AND A.INVENTORY_ITEM_ID = CF_17FORMULA.V_INVENTORY_ITEM_ID
420: AND A.DR_BASIC_ED = CF_4;
421: CURSOR SLNO2(V_INVENTORY_ITEM_ID IN NUMBER) IS