APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_PR_S_OU_PRG_CAL

Line 901: FROM igs_pr_s_ou_prg_cal sopc

897: --
898: --
899: CURSOR c_sopc (cp_version_number igs_ps_ver.version_number%TYPE) IS
900: SELECT 'X'
901: FROM igs_pr_s_ou_prg_cal sopc
902: WHERE igs_pr_gen_001.prgp_get_crv_cmt (p_course_cd, cp_version_number, sopc.org_unit_cd, sopc.ou_start_dt) = 'Y';
903: --
904: --
905: --

Line 912: FROM igs_pr_s_ou_prg_cal sopc,

908: cp_version_number igs_ps_ver.version_number%TYPE
909: ) IS
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