APPS.IGS_PS_SCH_INT_API_PUB dependencies on IGS_AD_BUILDING_ALL

Line 73: CURSOR c_bld(cp_n_building_id igs_ad_building_all.building_id%TYPE) IS

69: WHERE cal_type = cp_c_cal_type AND
70: sequence_number = cp_n_sequence_number;
71:
72: -- Cursor added as part of Enh bug#2833850
73: CURSOR c_bld(cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
74: SELECT 'x'
75: FROM igs_ad_building_all
76: WHERE building_id = cp_n_building_id;
77:

Line 75: FROM igs_ad_building_all

71:
72: -- Cursor added as part of Enh bug#2833850
73: CURSOR c_bld(cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
74: SELECT 'x'
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

Line 86: cp_n_building_id igs_ad_building_all.building_id%TYPE) IS

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
90: WHERE room_id = cp_n_room_id AND

Line 818: CURSOR c_bld(cp_n_building_id igs_ad_building_all.building_id%TYPE) IS

814: WHERE psi.int_occurs_id = cp_int_occurs_id AND
815: psi.int_usec_id = ps.int_usec_id;
816:
817: -- Cursor added as part of Enh bug#2833850
818: CURSOR c_bld(cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
819: SELECT 'x'
820: FROM igs_ad_building_all
821: WHERE building_id = cp_n_building_id;
822:

Line 820: FROM igs_ad_building_all

816:
817: -- Cursor added as part of Enh bug#2833850
818: CURSOR c_bld(cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
819: SELECT 'x'
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

Line 831: cp_n_building_id igs_ad_building_all.building_id%TYPE) IS

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
835: building_id = cp_n_building_id;