APPS.IGS_PE_SET_REM_HOLDS SQL Statements

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

Line: 50

    SELECT meaning
    FROM   igs_lookups_view
    WHERE  lookup_code = x_code
    AND    lookup_type = x_type ;

Line: 144

    L_select VARCHAR2(32767) := 'SELECT p.person_id,p.person_number,p.full_name FROM igs_pe_person_base_v p WHERE p.person_id IN ';

Line: 236

   L_select := L_select||'('||L_str||')';

Line: 239

    OPEN c_cur_query FOR L_select USING p_pid_group ;

Line: 241

    OPEN c_cur_query FOR L_select;

Line: 257

		igs_pe_pers_encumb_pkg.insert_row
        (
              x_mode                     =>   'R'                     ,
              x_rowid                    =>   l_rowid                 ,
              x_person_id                =>   r_rec_query.person_id    ,
              x_encumbrance_type         =>   p_hold_type             ,
              x_start_dt                 =>   l_start_date            ,
              x_expiry_dt                =>   NULL                    ,
              x_authorising_person_id    =>   l_person_id,
              x_comments                 =>   NULL                    ,
              x_spo_course_cd            =>   NULL                    ,
              x_spo_sequence_number      =>   NULL                    ,
              x_cal_type                 =>   l_cal_type              ,
              x_sequence_number          =>   l_seq_num ,
              x_auth_resp_id             =>   l_resp_id ,
              x_external_reference       =>   NULL   -- this should be explicitly NULL while coming from Internal system
        ) ;

Line: 400

    SELECT           *
    FROM             IGS_PE_PERS_ENCUMB
    WHERE            person_id         = cp_person_id
    AND              encumbrance_type  = cp_hold_type
    AND              start_dt          = cp_start_dt
    AND              (expiry_dt IS NULL OR SYSDATE < expiry_dt);

Line: 411

    L_select VARCHAR2(32767) := 'SELECT p.person_id,p.person_number,p.full_name FROM igs_pe_person_base_v p WHERE p.person_id IN ';

Line: 505

    L_select := L_select||'('||L_str||')';

Line: 509

    OPEN c_cur_query FOR L_select USING p_pid_group ;

Line: 511

    OPEN c_cur_query FOR L_select;