eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_CA_STAT

Line 877: igs_ca_stat cs

873: SELECT ci.cal_type,
874: ci.sequence_number
875: FROM igs_pr_s_crv_prg_cal scpc,
876: igs_ca_inst ci,
877: igs_ca_stat cs
878: WHERE scpc.course_cd = p_course_cd
879: AND scpc.version_number = cp_version_number
880: AND ci.cal_type = scpc.prg_cal_type
881: AND ci.cal_status = cs.cal_status

Line 914: igs_ca_stat cs

910: SELECT ci.cal_type,
911: ci.sequence_number
912: FROM igs_pr_s_ou_prg_cal sopc,
913: igs_ca_inst ci,
914: igs_ca_stat cs
915: WHERE igs_pr_gen_001.prgp_get_crv_cmt (p_course_cd, cp_version_number, sopc.org_unit_cd, sopc.ou_start_dt) = 'Y'
916: AND ci.cal_type = sopc.prg_cal_type
917: AND ci.cal_status = cs.cal_status
918: AND cs.s_cal_status = 'ACTIVE'

Line 940: igs_ca_stat cs

936: SELECT ci.cal_type,
937: ci.sequence_number
938: FROM igs_pr_s_prg_cal spc,
939: igs_ca_inst ci,
940: igs_ca_stat cs
941: WHERE spc.s_control_num = 1
942: AND ci.cal_type = spc.prg_cal_type
943: AND ci.cal_status = cs.cal_status
944: AND cs.s_cal_status = 'ACTIVE'