DBA Data[Home] [Help]

APPS.IGS_AS_GEN_004 dependencies on IGS_AS_GPC_PROGRAMS

Line 867: FROM igs_as_gpc_programs gpr

863: AND ucl.closed_ind = 'N'
864: AND sua.unit_attempt_status IN ('ENROLLED', 'COMPLETED', 'DISCONTIN')
865: AND (p_grading_period_cd = 'FINAL'
866: OR (EXISTS ( SELECT 'x'
867: FROM igs_as_gpc_programs gpr
868: WHERE gpr.course_cd = sua.course_cd)
869: OR EXISTS ( SELECT 'x'
870: FROM igs_en_stdnt_ps_att sca,
871: igs_as_gpc_aca_stndg gas

Line 935: FROM igs_as_gpc_programs gpr

931: AND ucl.unit_mode = cp_unit_mode
932: AND sua.unit_attempt_status IN ('ENROLLED', 'COMPLETED', 'DISCONTIN')
933: AND (p_grading_period_cd = 'FINAL'
934: OR (EXISTS ( SELECT 'x'
935: FROM igs_as_gpc_programs gpr
936: WHERE gpr.course_cd = sua.course_cd)
937: OR EXISTS ( SELECT 'x'
938: FROM igs_en_stdnt_ps_att sca,
939: igs_as_gpc_aca_stndg gas