DBA Data[Home] [Help]

APPS.JAI_CMN_RG_PLA_TRXS_PKG dependencies on DUAL

Line 102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;

98: lv_statement_id VARCHAR2(5);
99:
100: -- added, Harshita for 4892111
101: Cursor c_fetch_register_id IS
102: select JAI_CMN_RG_PLA_TRXS_S1.nextval from dual ;
103:
104: ln_register_id jai_cmn_rg_pla_trxs.register_id%type ;
105: -- ended, Harshita for 4892111
106:

Line 608: This Procedure is Created for Textile Industry specifically wherin individual

604: FILENAME: jai_cmn_rg_pla_trxs_pkg.generate_component_balances.sql
605: CHANGE HISTORY:
606:
607: 1. 2002/07/28 Nagaraj.s - For Enh#2371031
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