APPS.JAI_CMN_RGM_SETUP_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 53

        SELECT RGM_DOCUMENT_SEQ_ID
        FROM jai_rgm_doc_seq_hdrs rhdr
        WHERE rhdr.regime_id            = p_regime_id
        AND   rhdr.party_id             = p_organization_id
        AND   rhdr.party_site_id        = p_location_id
        AND   TRUNC(p_date)  between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line: 64

        SELECT rgm_document_seq_id
        FROM jai_rgm_doc_seq_hdrs rhdr
        WHERE rhdr.regime_id            = p_regime_id
        AND   rhdr.registration_num     = ln_regnum
        AND   TRUNC(p_date)  between TRUNC(rhdr.effective_from) and NVL(TRUNC(rhdr.effective_to) ,sysdate) ;

Line: 76

                select attribute_value
                from   JAI_RGM_ORG_REGNS_V
                where  regime_id = p_regime_id
                and    organization_id = p_organization_id
                and    location_id = p_location_id
                and    attribute_type_Code =  p_att_type_code
                and    attribute_code = p_att_code  ;

Line: 89

        SELECT rgm_document_seq_dtl_id
        FROM jai_rgm_doc_seq_dtls   rdtl
        WHERE rdtl.rgm_document_seq_id          = ln_seq_id
        AND   rdtl.document_class               = p_doc_class
        AND   rdtl.document_class_type_id       =   decode(p_doc_class, 'R', -8888,	  'UR', -8888, --csahoo bug 5233925
                                      p_doc_type_id) ;

Line: 98

        SELECT rgm_document_seq_dtl_id
        FROM jai_rgm_doc_seq_dtls
        WHERE rgm_document_seq_id = ln_seq_id
        AND    document_class      = DECODE(p_doc_class,'O','D','UO','UD','UI','UD','I','D','R','D','UR','UD',p_doc_class);

Line: 106

        SELECT prefix,current_number,end_number
        FROM jai_rgm_doc_seq_dtls
        WHERE rgm_document_seq_dtl_id = ln_seq_dtl_id
	FOR UPDATE of current_number ;   /* Added 'FOR UPDATE OF current_number' by ssawant for bug#5603661 */

Line: 145

                        UPDATE jai_rgm_doc_seq_dtls
                        SET  current_number = ln_current
                        WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;

Line: 181

                                UPDATE jai_rgm_doc_seq_dtls
                                SET  current_number = ln_current
                                WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;

Line: 238

                              UPDATE jai_rgm_doc_seq_dtls
                              SET  current_number = ln_current
                              WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;

Line: 272

                              UPDATE jai_rgm_doc_seq_dtls
                              SET  current_number = ln_current
                              WHERE rgm_document_seq_dtl_id  = ln_seq_dtl_id ;