APPS.IGS_GE_VAL_PARAM SQL Statements

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

Line: 23

SELECT
        'x'
FROM    IGS_PS_UNIT_VER    UV,
        IGS_PS_UNIT_STAT     UNS
WHERE
        uv.unit_cd              LIKE    cp_unit_cd
AND     uns.unit_status         =       uv.unit_status
AND     uns.s_unit_status       =       'ACTIVE';

Line: 81

SELECT
        'x'
FROM    IGS_AD_LOCATION        LOC
WHERE
        loc.location_cd LIKE    cp_loc_cd
AND     loc.closed_ind  =       'N';

Line: 137

SELECT
        'x'
FROM    IGS_EN_ATD_MODE atm
WHERE
        atm.attendance_mode     LIKE    cp_att_mode
AND     atm.closed_ind          =       'N';

Line: 193

SELECT
        'x'
FROM    IGS_EN_ATD_TYPE att
WHERE
        att.attendance_type     LIKE    cp_att_type
AND     att.closed_ind          =       'N';

Line: 249

SELECT
        'x'
FROM    IGS_AS_UNIT_CLASS              UC
WHERE
         uc.unit_class   LIKE    cp_unit_class
AND     uc.closed_ind   =       'N';

Line: 306

SELECT
        'x'
FROM    IGS_AS_UNIT_MODE       um
WHERE
         um.unit_mode    LIKE    cp_unit_mode
AND     um.closed_ind   =       'N';

Line: 363

SELECT
        'x'
FROM    IGS_PS_TYPE     CT
WHERE
         ct.course_type  LIKE    cp_crs_type
AND     ct.closed_ind   =       'N';

Line: 420

SELECT
        'x'
FROM    IGS_EN_ENROLMENT_CAT   EC
WHERE
         ec.enrolment_cat        LIKE    cp_enr_cat
AND     ec.closed_ind   =       'N';

Line: 477

SELECT
        'x'
FROM    IGS_AD_CAT   ADC
WHERE
         adc.admission_cat       LIKE    cp_adm_cat
AND     adc.closed_ind  =       'N';

Line: 534

SELECT
        'x'
FROM    IGS_FI_FEE_CAT fc
WHERE
         fc.fee_cat      LIKE    cp_fee_cat
AND     fc.closed_ind   =       'N';

Line: 622

SELECT
        'x'
FROM    IGS_AS_UNIT_CLASS uc
WHERE   uc.unit_class   LIKE    cp_unit_class
AND     uc.unit_mode    LIKE    cp_unit_mode
AND     uc.closed_ind = 'N';

Line: 673

SELECT  'x'
FROM    IGS_PS_VER  cv,
        IGS_PS_STAT   cs
WHERE   course_cd LIKE cp_course_cd
AND     cs.course_status        =       cv.course_status
AND     cs.s_course_status      =       'ACTIVE';

Line: 736

SELECT
        TO_CHAR(asi.ass_id) || ' - ' ||
        asi.description
FROM    IGS_AS_ASSESSMNT_ITM asi
WHERE   asi.ass_id      =       cp_ass_id;

Line: 801

 SELECT  RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
        IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
        IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
        RPAD(ci.cal_type, 10) ||
        TO_CHAR(ci.sequence_number, '999990')   cal_desc
FROM    IGS_CA_TYPE        ct,
        IGS_CA_INST    ci,
        IGS_CA_STAT      cs
WHERE   ct.s_cal_cat    = cp_s_cal_cat  AND
        ci.cal_type     = ct.cal_type   AND
        cs.cal_status   = ci.cal_status AND
        cs.s_cal_status	= 'ACTIVE'	AND
        ci.start_dt     < SYSDATE       AND
        ci.end_dt       > SYSDATE;

Line: 860

 SELECT  RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
        IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
        IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
         RPAD(ci.cal_type, 10) ||
        TO_CHAR(ci.sequence_number, '999990')   cal_desc
FROM    IGS_CA_TYPE        ct,
        IGS_CA_INST    ci
WHERE   ct.cal_type             =       cp_cal_type     AND
        ci.cal_type             =       ct.cal_type     AND
        ci.sequence_number      =       cp_seq_num;

Line: 902

 SELECT  RPAD(RPAD(NVL(ci.alternate_code, ci.cal_type), 10) || ' ' ||
        IGS_GE_DATE.igschar(ci.start_dt) || ' - ' ||
        IGS_GE_DATE.igschar(ci.end_dt) || ' ' || ct.abbreviation, 100) ||
        RPAD(ci.cal_type, 10) ||
        TO_CHAR(ci.sequence_number, '999990')   cal_desc
FROM    IGS_CA_TYPE        ct,
        IGS_CA_INST    ci
WHERE   ct.cal_type             =       cp_cal_type     AND
        ci.cal_type             =       ct.cal_type     AND
        ci.sequence_number      =       cp_seq_num;

Line: 939

SELECT  'x'
FROM    IGS_OR_UNIT        ou,
        IGS_OR_STATUS      ous
WHERE   org_unit_cd LIKE cp_org_cd
AND     ous.org_status  =       ou.org_status
AND     ous.s_org_status        =       'ACTIVE';