APPS.JAI_CMN_RG_PLA_TRXS_PKG dependencies on JAI_CMN_RG_PLA_CMP_DTLS

Line 583: FROM JAI_CMN_RG_PLA_CMP_DTLS B

579: A.TRANSACTION_DATE,
580: A.LAST_UPDATE_LOGIN
581: FROM JAI_CMN_RG_PLA_TRXS A
582: WHERE NOT EXISTS ( SELECT '1'
583: FROM JAI_CMN_RG_PLA_CMP_DTLS B
584: WHERE B.REGISTER_ID = A.REGISTER_ID
585: AND B.SLNO = A.SLNO)
586: ORDER BY REGISTER_ID,SLNO;
587:

Line 612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data

608: This Procedure is Created for Textile Industry specifically wherin individual
609: balances of Excise components are to be maintained.
610: In case of data not existing in Excise Component Balances for an combination of
611: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data
613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
614:
615: -----------------------------------------------------------------------------------------------
616: */

Line 613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.

609: balances of Excise components are to be maintained.
610: In case of data not existing in Excise Component Balances for an combination of
611: Organization/Location, this will inserts data into JAI_CMN_RG_COMP_BALS
612: and JAI_CMN_RG_PLA_CMP_DTLS tables and if data exists, then it will insert data
613: into JAI_CMN_RG_PLA_CMP_DTLS and updates JAI_CMN_RG_COMP_BALS table.
614:
615: -----------------------------------------------------------------------------------------------
616: */
617:

Line 689: INSERT INTO JAI_CMN_RG_PLA_CMP_DTLS

685: V_OTHER_CLOSING_BALANCE := V_OTHER_OPENING_BALANCE + NVL(CUR_REC.CR_OTHER_ED,0) - NVL(CUR_REC.DR_OTHER_ED,0);
686: END;
687:
688:
689: INSERT INTO JAI_CMN_RG_PLA_CMP_DTLS
690: (
691: ORGANIZATION_ID,
692: LOCATION_ID,
693: INVENTORY_ITEM_ID,