APPS.IGS_AS_ADI_UPLD_PR_PKG dependencies on IGS_PR_GEN_001

Line 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';

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: --
906: CURSOR c_sopc_ci (

Line 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'

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'
919: AND ci.start_dt < SYSDATE