APPS.IGS_PR_ACAD_DETAILS SQL Statements

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

Line: 44

    SELECT 'X'
    FROM   igs_as_grd_sch_grade  gsg
    WHERE  cp_grading_schema_cd = gsg.grading_schema_cd
    AND    cp_version_number    = gsg.version_number
    AND    cp_grade             = gsg.grade
    AND    gsg.show_on_official_ntfctn_ind = 'Y';

Line: 623

    SELECT us.unit_set_cd
    FROM   IGS_AS_SU_SETATMPT SUSA,
           IGS_EN_UNIT_SET US,
           IGS_EN_UNIT_SET_CAT USC
    WHERE  p_person_id = susa.person_id
    AND    p_course_cd = susa.course_cd
    AND    (igs_en_gen_015.get_effective_census_date(
           NULL, NULL, p_teach_cal_type, p_teach_ci_sequence_number)
           BETWEEN susa.selection_dt AND NVL(susa.rqrmnts_complete_dt,
           NVL(susa.end_dt, fnd_date.canonical_to_date('9999/12/31'))))
    AND    susa.unit_set_cd = us.unit_set_cd
    AND    us.unit_set_cat = usc.unit_set_cat
    AND    usc.s_unit_set_cat = 'PRENRL_YR'
    ORDER BY susa.selection_dt DESC;