APPS.IGS_PS_VALIDATE_GENERIC_PKG dependencies on IGS_PS_US_EXAM_MEET

Line 67: CURSOR c_check_host(cp_uoo_id IN igs_ps_us_exam_meet.exam_meet_group_id%TYPE) IS

63: Known limitations,enhancements,remarks:
64: Change History (in reverse chronological order)
65: Who When What
66: ********************************************************************************************** */
67: CURSOR c_check_host(cp_uoo_id IN igs_ps_us_exam_meet.exam_meet_group_id%TYPE) IS
68: SELECT host
69: FROM igs_ps_us_exam_meet
70: WHERE uoo_id = cp_uoo_id;
71:

Line 69: FROM igs_ps_us_exam_meet

65: Who When What
66: ********************************************************************************************** */
67: CURSOR c_check_host(cp_uoo_id IN igs_ps_us_exam_meet.exam_meet_group_id%TYPE) IS
68: SELECT host
69: FROM igs_ps_us_exam_meet
70: WHERE uoo_id = cp_uoo_id;
71:
72: l_host igs_ps_us_exam_meet.host%TYPE;
73:

Line 72: l_host igs_ps_us_exam_meet.host%TYPE;

68: SELECT host
69: FROM igs_ps_us_exam_meet
70: WHERE uoo_id = cp_uoo_id;
71:
72: l_host igs_ps_us_exam_meet.host%TYPE;
73:
74: CURSOR c_building(cp_building_id igs_ad_building_all.building_id%TYPE,
75: cp_location_cd igs_ad_building_all.location_cd%TYPE ) IS
76: SELECT 'X'