APPS.IGS_EN_GEN_009 dependencies on IGS_PS_UNIT_VER

Line 2739: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS

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
2743: AND posu.unit_cd = cp_unit_cd;

Line 3164: cp_unit_cd igs_ps_unit_ver.unit_cd%TYPE) IS

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
3168: AND posu.unit_cd = cp_unit_cd;