APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_LOOKUP_VALUES

Line 2282: FROM igs_lookup_values

2278: -- Cursor added as part of bug#2833850
2279: -- Cursor to get region code information to be exported to flat file
2280: CURSOR c_region IS
2281: SELECT lookup_code,meaning,description,tag,start_date_active,end_date_active,enabled_flag,closed_ind
2282: FROM igs_lookup_values
2283: WHERE lookup_type = 'IGS_OR_LOC_REGION'
2284: AND enabled_flag = 'Y'
2285: AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(start_date_active,TRUNC(SYSDATE))) AND TRUNC(NVL(end_date_active,TRUNC(SYSDATE)))
2286: ORDER BY lookup_code;

Line 2293: FROM IGS_LOOKUP_VALUES

2289:
2290: -- Cursor to select the filename to export room information
2291: CURSOR c_room_fname IS
2292: SELECT meaning
2293: FROM IGS_LOOKUP_VALUES
2294: WHERE LOOKUP_TYPE='SCHED_EXP_FILES' AND
2295: LOOKUP_CODE='IGS_PS_SCH_ROOM' ;
2296:
2297: -- Cursor to select the filename to export building information

Line 2300: FROM IGS_LOOKUP_VALUES

2296:
2297: -- Cursor to select the filename to export building information
2298: CURSOR c_building_fname IS
2299: SELECT meaning
2300: FROM IGS_LOOKUP_VALUES
2301: WHERE LOOKUP_TYPE='SCHED_EXP_FILES' AND
2302: LOOKUP_CODE='IGS_PS_SCH_BLDG';
2303:
2304: -- Cursor to select the filename to export location information

Line 2307: FROM IGS_LOOKUP_VALUES

2303:
2304: -- Cursor to select the filename to export location information
2305: CURSOR c_location_fname IS
2306: SELECT meaning
2307: FROM IGS_LOOKUP_VALUES
2308: WHERE LOOKUP_TYPE='SCHED_EXP_FILES' AND
2309: LOOKUP_CODE='IGS_PS_SCH_LOC';
2310:
2311: -- Cursor added as part of bug#2833850

Line 2315: FROM IGS_LOOKUP_VALUES

2311: -- Cursor added as part of bug#2833850
2312: -- Cursor to select the filename to export preferred region information
2313: CURSOR c_reg_fname IS
2314: SELECT meaning
2315: FROM IGS_LOOKUP_VALUES
2316: WHERE LOOKUP_TYPE='SCHED_EXP_FILES' AND
2317: LOOKUP_CODE='IGS_PS_SCH_PRF_REG';
2318:
2319: -- local variables to hold the export flat file name, Added as a part of Bug # 2401826

Line 4409: CURSOR cur_lookup_meaning (cp_lookup_type igs_lookup_values.lookup_type%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
4411: SELECT meaning
4412: FROM igs_lookup_values
4413: WHERE lookup_type=cp_lookup_type

Line 4410: cp_lookup_code igs_lookup_values.lookup_code%TYPE) IS

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
4411: SELECT meaning
4412: FROM igs_lookup_values
4413: WHERE lookup_type=cp_lookup_type
4414: AND lookup_code=cp_lookup_code;

Line 4412: FROM igs_lookup_values

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
4411: SELECT meaning
4412: FROM igs_lookup_values
4413: WHERE lookup_type=cp_lookup_type
4414: AND lookup_code=cp_lookup_code;
4415: l_prf_reg_desc igs_lookup_values.meaning%TYPE;
4416: l_sch_status_desc igs_lookup_values.meaning%TYPE;

Line 4415: l_prf_reg_desc igs_lookup_values.meaning%TYPE;

4411: SELECT meaning
4412: FROM igs_lookup_values
4413: WHERE lookup_type=cp_lookup_type
4414: AND lookup_code=cp_lookup_code;
4415: l_prf_reg_desc igs_lookup_values.meaning%TYPE;
4416: l_sch_status_desc igs_lookup_values.meaning%TYPE;
4417:
4418: BEGIN
4419:

Line 4416: l_sch_status_desc igs_lookup_values.meaning%TYPE;

4412: FROM igs_lookup_values
4413: WHERE lookup_type=cp_lookup_type
4414: AND lookup_code=cp_lookup_code;
4415: l_prf_reg_desc igs_lookup_values.meaning%TYPE;
4416: l_sch_status_desc igs_lookup_values.meaning%TYPE;
4417:
4418: BEGIN
4419:
4420: OPEN c_ins_name(p_n_lead_instructor_id);