APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_AD_BUILDING

Line 2269: FROM igs_ad_building

2265:
2266: -- Cursor to get building information to be exported to flat file
2267: CURSOR c_building IS
2268: SELECT building_id,location_cd,building_cd,description,closed_ind
2269: FROM igs_ad_building
2270: ORDER BY 1;
2271:
2272: -- Cursor to get location information to be exported to flat file
2273: CURSOR c_location IS

Line 2678: CURSOR c_bldg_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE) IS

2674: WHERE a.uoo_id = cp_n_uoo_id
2675: AND a.cal_type = b.cal_type
2676: AND a.ci_sequence_number = b.sequence_number;
2677:
2678: CURSOR c_bldg_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
2679: SELECT 'x'
2680: FROM igs_ad_building_all
2681: WHERE building_id = cp_n_building_id
2682: AND ROWNUM < 2 ;

Line 2680: FROM igs_ad_building_all

2676: AND a.ci_sequence_number = b.sequence_number;
2677:
2678: CURSOR c_bldg_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE) IS
2679: SELECT 'x'
2680: FROM igs_ad_building_all
2681: WHERE building_id = cp_n_building_id
2682: AND ROWNUM < 2 ;
2683:
2684: CURSOR c_room_exists (cp_n_room_id igs_ad_room_all.room_id%TYPE) IS

Line 2690: CURSOR c_bldg_room_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE,

2686: FROM igs_ad_room_all
2687: WHERE room_id = cp_n_room_id
2688: AND ROWNUM < 2 ;
2689:
2690: CURSOR c_bldg_room_exists (cp_n_building_id igs_ad_building_all.building_id%TYPE,
2691: cp_n_room_id igs_ad_room_all.room_id%TYPE) IS
2692: SELECT 'x'
2693: FROM igs_ad_room_all
2694: WHERE building_id = cp_n_building_id

Line 4393: CURSOR bld_desc(cp_bld_code igs_ad_building_all.building_id%TYPE) IS

4389:
4390: rec_ins_name c_ins_name%ROWTYPE;
4391: l_str VARCHAR2(1000);
4392:
4393: CURSOR bld_desc(cp_bld_code igs_ad_building_all.building_id%TYPE) IS
4394: SELECT description
4395: FROM igs_ad_building_all
4396: WHERE building_id = cp_bld_code;
4397:

Line 4395: FROM igs_ad_building_all

4391: l_str VARCHAR2(1000);
4392:
4393: CURSOR bld_desc(cp_bld_code igs_ad_building_all.building_id%TYPE) IS
4394: SELECT description
4395: FROM igs_ad_building_all
4396: WHERE building_id = cp_bld_code;
4397:
4398: CURSOR rom_desc(cp_rom_code igs_ad_room_all.room_id%TYPE) IS
4399: SELECT description

Line 4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;

4398: CURSOR rom_desc(cp_rom_code igs_ad_room_all.room_id%TYPE) IS
4399: SELECT description
4400: FROM igs_ad_room_all
4401: WHERE room_id = cp_rom_code;
4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;
4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;
4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;
4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;

Line 4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;

4400: FROM igs_ad_room_all
4401: WHERE room_id = cp_rom_code;
4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;
4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;
4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;
4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;
4407: l_prf_rom_desc igs_ad_room_all.description%TYPE;
4408:

Line 4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;

4402: l_sch_bld_desc igs_ad_building_all.description%TYPE;
4403: l_sch_rom_desc igs_ad_room_all.description%TYPE;
4404: l_ded_bld_desc igs_ad_building_all.description%TYPE;
4405: l_ded_rom_desc igs_ad_room_all.description%TYPE;
4406: l_prf_bld_desc igs_ad_building_all.description%TYPE;
4407: l_prf_rom_desc igs_ad_room_all.description%TYPE;
4408:
4409: CURSOR cur_lookup_meaning (cp_lookup_type igs_lookup_values.lookup_type%TYPE,
4410: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS