APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_PS_VER

Line 863: CURSOR c_scpc (cp_version_number igs_ps_ver.version_number%TYPE) IS

859: AND spo.prg_ci_sequence_number = cp_prg_ci_sequence_number;
860: --
861: -- Determine the current progression period
862: --
863: CURSOR c_scpc (cp_version_number igs_ps_ver.version_number%TYPE) IS
864: SELECT 'X'
865: FROM igs_pr_s_crv_prg_cal scpc
866: WHERE scpc.course_cd = p_course_cd
867: AND scpc.version_number = cp_version_number;

Line 871: cp_version_number igs_ps_ver.version_number%TYPE

867: AND scpc.version_number = cp_version_number;
868:
869: CURSOR c_scpc_ci (
870: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
871: cp_version_number igs_ps_ver.version_number%TYPE
872: ) IS
873: SELECT ci.cal_type,
874: ci.sequence_number
875: FROM igs_pr_s_crv_prg_cal scpc,

Line 899: CURSOR c_sopc (cp_version_number igs_ps_ver.version_number%TYPE) IS

895: ORDER BY ci.end_dt DESC;
896: --
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: --

Line 908: cp_version_number igs_ps_ver.version_number%TYPE

904: --
905: --
906: CURSOR c_sopc_ci (
907: cp_person_id igs_en_stdnt_ps_att.person_id%TYPE,
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,