APPS.IGS_PS_UNITASS_ITEM_PKG dependencies on IGS_CA_INST

Line 242: CURSOR c_ci (cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) IS

238: p_inserting IN BOOLEAN DEFAULT FALSE,
239: p_updating IN BOOLEAN DEFAULT FALSE,
240: p_deleting IN BOOLEAN DEFAULT FALSE
241: ) AS
242: CURSOR c_ci (cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) IS
243: SELECT start_dt,
244: end_dt
245: FROM igs_ca_inst
246: WHERE cal_type = cp_cal_type

Line 245: FROM igs_ca_inst

241: ) AS
242: CURSOR c_ci (cp_cal_type igs_ca_inst.cal_type%TYPE, cp_seq_number igs_ca_inst.sequence_number%TYPE) IS
243: SELECT start_dt,
244: end_dt
245: FROM igs_ca_inst
246: WHERE cal_type = cp_cal_type
247: AND sequence_number = cp_seq_number;
248: BEGIN
249: IF p_inserting THEN