APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_AD_ROOM_ALL

Line 79: CURSOR c_room(cp_n_room_id igs_ad_room_all.room_id%TYPE) IS

75: FROM igs_ad_building_all
76: WHERE building_id = cp_n_building_id;
77:
78: -- Cursor added as part of Enh bug#2833850
79: CURSOR c_room(cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
80: SELECT 'x'
81: FROM igs_ad_room_all
82: WHERE room_id = cp_n_room_id;
83:

Line 81: FROM igs_ad_room_all

77:
78: -- Cursor added as part of Enh bug#2833850
79: CURSOR c_room(cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
80: SELECT 'x'
81: FROM igs_ad_room_all
82: WHERE room_id = cp_n_room_id;
83:
84: -- Cursor added as part of Enh bug#2833850
85: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,

Line 85: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,

81: FROM igs_ad_room_all
82: WHERE room_id = cp_n_room_id;
83:
84: -- Cursor added as part of Enh bug#2833850
85: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,
86: cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
87:
88: SELECT 'x'
89: FROM igs_ad_room_all

Line 89: FROM igs_ad_room_all

85: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,
86: cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
87:
88: SELECT 'x'
89: FROM igs_ad_room_all
90: WHERE room_id = cp_n_room_id AND
91: building_id = cp_n_building_id;
92:
93: -- Local variables added as part of Enh bug#2833850

Line 824: CURSOR c_room(cp_n_room_id igs_ad_room_all.room_id%TYPE) IS

820: FROM igs_ad_building_all
821: WHERE building_id = cp_n_building_id;
822:
823: -- Cursor added as part of Enh bug#2833850
824: CURSOR c_room(cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
825: SELECT 'x'
826: FROM igs_ad_room_all
827: WHERE room_id = cp_n_room_id;
828:

Line 826: FROM igs_ad_room_all

822:
823: -- Cursor added as part of Enh bug#2833850
824: CURSOR c_room(cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
825: SELECT 'x'
826: FROM igs_ad_room_all
827: WHERE room_id = cp_n_room_id;
828:
829: -- Cursor added as part of Enh bug#2833850
830: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,

Line 830: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,

826: FROM igs_ad_room_all
827: WHERE room_id = cp_n_room_id;
828:
829: -- Cursor added as part of Enh bug#2833850
830: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,
831: cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
832: SELECT 'x'
833: FROM igs_ad_room_all
834: WHERE room_id = cp_n_room_id AND

Line 833: FROM igs_ad_room_all

829: -- Cursor added as part of Enh bug#2833850
830: CURSOR c_bld_room(cp_n_room_id igs_ad_room_all.room_id%TYPE,
831: cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
832: SELECT 'x'
833: FROM igs_ad_room_all
834: WHERE room_id = cp_n_room_id AND
835: building_id = cp_n_building_id;
836:
837: -- Local variables added as part of Enh bug#2833850