APPS.IGS_AS_GEN_008 SQL Statements

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

Line: 12

CURSOR c_ps(gp_cd varchar2,p_id number) is select 'X' from igs_en_stdnt_ps_att_all a, igs_as_gpc_aca_stndg b
                                                    where  a.progression_status =b.progression_status
                                                    and    b.grading_period_cd = gp_cd
                                                    and    a.person_id = p_id;

Line: 17

CURSOR c_pr(gp_cd varchar2,p_id number) is select 'X' from igs_en_stdnt_ps_att_all a, igs_as_gpc_programs b
                                                    where a.course_cd = b.course_cd
                                                    and   a.version_number = b.course_version_number
                                                    and   b.grading_period_cd = gp_cd
                                                    and   a.person_id = p_id
                                                    and   a.COURSE_ATTEMPT_STATUS = 'ENROLLED';

Line: 24

CURSOR c_us(gp_cd varchar2,p_id number) is select 'X' from igs_as_su_setatmpt a, igs_as_gpc_unit_sets b
                                                    where a.unit_set_cd = b.unit_set_cd
                                                    and   b.grading_period_cd = gp_cd
                                                    and   a.person_id = p_id;

Line: 29

CURSOR c_pg(gp_cd varchar2,p_id number) is select 'X' from igs_pe_prsid_grp_mem_all a, igs_as_gpc_pe_id_grp b
                                                    where a.group_id = b.group_id
                                                    and   b.grading_period_cd = gp_cd
                                                    and   a.person_id = p_id;

Line: 34

CURSOR c_cs(gp_cd varchar2,p_id number,unit_cd varchar2,course_cd varchar2) is select 'X' from igs_as_gpc_cls_stndg a,igs_en_su_attempt_all b
                                                                             where   a.grading_period_cd = gp_cd
                                                                             and   b.unit_cd= unit_cd
                                                                             and   b.course_cd= course_cd
                                                                             and   b.person_id = p_id
                                                                             and   a.class_standing = Igs_Pr_Get_Class_Std.get_class_standing (p_id,b.course_cd,'N',sysdate,load_cal_type,load_ci_sequence_number);

Line: 141

	SELECT suao.grade
	FROM   igs_as_suaoa_v        suao,
       	       igs_as_grd_sch_grade  gsg
	WHERE  suao.person_id = p_person_id
	AND    suao.unit_cd = p_unit_cd
	AND    (suao.course_cd <> p_course_cd
        -- anilk, 22-Apr-2003, Bug# 2829262
	OR     suao.uoo_id <> p_uoo_id)
	AND    suao.finalised_outcome_ind = 'Y'
	AND    suao.grading_period_cd = 'FINAL'
	AND    suao.grading_schema_cd = gsg.grading_schema_cd
	AND    suao.version_number = gsg.version_number
	AND    suao.grade = gsg.repeat_grade;

Line: 187

SELECT
 uoo_id,
 DECODE(a.monday,  'Y',     'MONDAY',  NULL) Monday,
 DECODE(a.tuesday,  'Y',    'TUESDAY',  NULL) Tuesday,
 DECODE(a.wednesday,  'Y',  'WEDNESDAY',  NULL) Wednesday,
 DECODE(a.thursday,  'Y',   'THURSDAY',  NULL) Thursday,
 DECODE(a.friday,  'Y',     'FRIDAY',  NULL) Friday,
 DECODE(a.saturday,  'Y',   'SATURDAY',  NULL) Saturday,
 DECODE(a.sunday,  'Y',     'SUNDAY',  NULL) Sunday,
 TO_CHAR(a.start_time,  'hh:miam')||'-'|| TO_CHAR(a.end_time,  'hh:miam')||' '||
 NVL(d.description,'-')||' '||
 NVL(b.description,'-')||'  '||
 NVL(c.description,'') location
 FROM igs_ps_usec_occurs a,
     igs_ad_building b,
     igs_ad_room c,
     igs_ad_location d
 WHERE
     a.building_code = b.building_id(+) AND
     a.room_code = c.room_id(+) AND
     b.location_cd = d.location_cd(+)  AND
       a.uoo_id = p_uoo_id and
     a.UNIT_SECTION_OCCURRENCE_ID = p_occurs_id;