APPS.IGS_EN_GEN_009 dependencies on IGS_PS_PAT_STUDY_PRD

Line 744: FROM IGS_PS_PAT_STUDY_PRD posp

740: cp_period_number NUMBER) IS
741: SELECT posp.acad_period_num,
742: posp.teach_cal_type,
743: posp.sequence_number
744: FROM IGS_PS_PAT_STUDY_PRD posp
745: WHERE posp.pos_sequence_number = cp_sequence_number AND
746: posp.acad_period_num >= cp_period_number AND
747: posp.acad_period_num < (cp_period_number
748: + cp_number_of_periods) AND

Line 801: cp_sequence_number IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE,

797:
798: -- Modified the cursor c_posu as part Core Vs Optional DLD.
799: -- pradhakr; 23-Sep-2002; Bug# 2581270
800: CURSOR c_posu (
801: cp_sequence_number IGS_PS_PAT_STUDY_PRD.sequence_number%TYPE,
802: cp_core_only VARCHAR2) IS
803: SELECT posu.unit_cd,
804: posu.unit_location_cd,
805: posu.unit_class,

Line 1100: -- IGS_PS_PAT_STUDY_PRD within the relevant academic

1096: EXIT;
1097: END IF;
1098: END IF;
1099: -- Select the teaching calendar instance matching the
1100: -- IGS_PS_PAT_STUDY_PRD within the relevant academic
1101: -- calendar instance.
1102: OPEN c_cir (v_aci_rec.cal_type,
1103: v_aci_rec.sequence_number,
1104: v_posp_rec.teach_cal_type);

Line 2726: FROM igs_ps_pat_study_prd posp

2722: cp_period_number NUMBER) IS
2723: SELECT posp.acad_period_num,
2724: posp.teach_cal_type,
2725: posp.sequence_number
2726: FROM igs_ps_pat_study_prd posp
2727: WHERE posp.pos_sequence_number = cp_sequence_number AND
2728: posp.acad_period_num >= cp_period_number AND
2729: posp.acad_period_num < (cp_period_number
2730: + cp_number_of_periods) AND

Line 2738: cp_sequence_number igs_ps_pat_study_prd.sequence_number%TYPE,

2734: posu.unit_cd IS NOT NULL)
2735: ORDER BY posp.acad_period_num;
2736:
2737: CURSOR c_posu (
2738: cp_sequence_number igs_ps_pat_study_prd.sequence_number%TYPE,
2739: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS
2740: SELECT core_ind
2741: FROM IGS_PS_PAT_STUDY_UNT posu
2742: WHERE posu.posp_sequence_number = cp_sequence_number

Line 3151: FROM igs_ps_pat_study_prd posp

3147: cp_period_number NUMBER) IS
3148: SELECT posp.acad_period_num,
3149: posp.teach_cal_type,
3150: posp.sequence_number
3151: FROM igs_ps_pat_study_prd posp
3152: WHERE posp.pos_sequence_number = cp_sequence_number AND
3153: posp.acad_period_num >= cp_period_number AND
3154: posp.acad_period_num < (cp_period_number
3155: + cp_number_of_periods) AND

Line 3163: cp_sequence_number igs_ps_pat_study_prd.sequence_number%TYPE,

3159: posu.unit_cd IS NOT NULL)
3160: ORDER BY posp.acad_period_num;
3161:
3162: CURSOR c_posu (
3163: cp_sequence_number igs_ps_pat_study_prd.sequence_number%TYPE,
3164: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS
3165: SELECT core_ind
3166: FROM IGS_PS_PAT_STUDY_UNT posu
3167: WHERE posu.posp_sequence_number = cp_sequence_number