APPS.IGS_RU_GEN_001 dependencies on IGS_PE_PERSON

Line 2996: -- igs_pe_person_refs_v is obsolete

2992: --Change History:
2993: --Who When What
2994: --kdande 25-Nov-2002 Removed entire code from the function and
2995: -- replaced it with true since the view
2996: -- igs_pe_person_refs_v is obsolete
2997: -------------------------------------------------------------------
2998: BEGIN
2999: RETURN 'true';
3000: END ref_set ; /** end of function ref_set **/

Line 3086: pp_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,

3082: WHERE atr.person_id = p_person_id
3083: AND atr.admission_test_type = h.admission_test_type
3084: AND h.up_header_id = d.up_header_id);
3085: PROCEDURE val_placement (pp_unit_cd IN IGS_PS_UNIT_VER.UNIT_CD%TYPE,
3086: pp_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
3087: pp_found OUT NOCOPY BOOLEAN)IS
3088:
3089: l_dummy VARCHAR2(1);
3090:

Line 3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,

3099: igs_ad_up_header hed
3100: WHERE det.up_header_id = hed.up_header_id
3101: AND det.unit_cd = cp_unit_cd
3102: AND det.closed_ind ='N';
3103: CURSOR cur_test(cp_person_id igs_pe_person.person_id%TYPE,
3104: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3105: cp_min_score igs_ad_up_header.min_score%TYPE,
3106: cp_max_score igs_ad_up_header.max_score%TYPE ) IS
3107: SELECT '1' FROM IGS_AD_TEST_RESULTS

Line 3112: CURSOR cur_seg (cp_person_id igs_pe_person.person_id%TYPE,

3108: WHERE person_id = cp_person_id
3109: AND admission_test_type = cp_admission_test_type
3110: AND NVL(comp_test_score,0) BETWEEN cp_min_score AND cp_max_score;
3111: --
3112: CURSOR cur_seg (cp_person_id igs_pe_person.person_id%TYPE,
3113: cp_admission_test_type igs_ad_up_header.admission_test_type%TYPE,
3114: cp_test_segment_id igs_ad_up_header.test_segment_id%TYPE,
3115: cp_min_score igs_ad_up_header.min_score%TYPE,
3116: cp_max_score igs_ad_up_header.max_score%TYPE ) IS