APPS.IGR_VAL_EAP SQL Statements

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

Line: 23

        SELECT  es.s_enquiry_status
        FROM    IGR_I_STATUS_V   es
        WHERE   es.enquiry_status   = p_enquiry_status;

Line: 28

        SELECT  'x'
        FROM    IGR_I_A_PKGITM_V eapmpi
        WHERE   eapmpi.person_id        = p_person_id AND
            eapmpi.enquiry_appl_number  = p_enquiry_appl_number;

Line: 33

        SELECT  'x'
        FROM    IGR_I_A_PKGITM_V eapmpi
        WHERE   eapmpi.person_id        = p_person_id AND
            eapmpi.enquiry_appl_number  = p_enquiry_appl_number AND
            eapmpi.mailed_dt        IS NULL;

Line: 115

        SELECT  s_cal_cat
        FROM    IGS_CA_TYPE
        WHERE   cal_type = cp_acad_cal_type;

Line: 121

        SELECT  cs.s_cal_status
        FROM    IGS_CA_STAT cs,
            IGS_CA_INST ci
        WHERE   ci.cal_type         = cp_acad_cal_type AND
            ci.sequence_number  = cp_acad_ci_sequence_number AND
            ci.cal_status   = cs.cal_status;

Line: 188

        SELECT  cat.s_cal_cat
        FROM    IGS_CA_TYPE cat
        WHERE   cat.cal_type = cp_cal_type;

Line: 194

        SELECT  cs.s_cal_status
        FROM    IGS_CA_INST ci,
            IGS_CA_STAT cs
        WHERE   ci.cal_status= cs.cal_status AND
            ci.cal_type = cp_cal_type AND
            ci.sequence_number = cp_sequence_number;

Line: 205

        SELECT  'x'
        FROM    IGS_CA_INST_REL cir
        WHERE   cir.sup_cal_type =cp_acad_cal_type AND
            cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
            cir.sub_cal_type = cp_adm_cal_type AND
            cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;

Line: 282

        SELECT  'X'
        FROM    IGS_PE_PERSON_ADDR      pa
        WHERE   pa.person_id        = p_person_id AND
            pa.correspondence_ind   = 'Y' AND
            (pa.status = 'A' AND
             SYSDATE BETWEEN NVL(pa.start_dt,SYSDATE) AND NVL(pa.end_dt,SYSDATE));

Line: 328

        SELECT  'X'
        FROM IGR_I_STATUS_V    es
        WHERE   es.enquiry_status   = p_enquiry_status and
            es.s_enquiry_status = 'OSS_REGISTERED';

Line: 385

        SELECT  es.s_enquiry_status
        FROM IGR_I_STATUS_V es
        WHERE   es.enquiry_status   = cp_enquiry_status;

Line: 389

        SELECT  'x'
        FROM    IGR_I_A_PKGITM_V eapmpi
        WHERE   eapmpi.person_id        = p_person_id AND
            eapmpi.enquiry_appl_number  = p_enquiry_appl_number AND
            eapmpi.mailed_dt        IS NULL;

Line: 470

        SELECT  'X'
        FROM    IGR_I_APPL   eap
        WHERE   eap.person_id = p_person_id AND
            eap.enquiry_appl_number = p_enquiry_appl_number AND
            eap.s_enquiry_status NOT IN ('OSS_REGISTERED','OSS_ACKNOWLEGE');