DBA Data[Home] [Help]

APPS.IGR_VAL_EAP dependencies on IGS_CA_INST

Line 123: IGS_CA_INST ci

119: cp_acad_cal_type IGR_I_APPL.acad_cal_type%TYPE,
120: cp_acad_ci_sequence_number IGR_I_APPL.acad_ci_sequence_number%TYPE) IS
121: SELECT cs.s_cal_status
122: FROM IGS_CA_STAT cs,
123: IGS_CA_INST ci
124: WHERE ci.cal_type = cp_acad_cal_type AND
125: ci.sequence_number = cp_acad_ci_sequence_number AND
126: ci.cal_status = cs.cal_status;
127: v_ct_rec c_ct%ROWTYPE;

Line 192: cp_cal_type IGS_CA_INST.cal_type%TYPE,

188: SELECT cat.s_cal_cat
189: FROM IGS_CA_TYPE cat
190: WHERE cat.cal_type = cp_cal_type;
191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs

Line 193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

189: FROM IGS_CA_TYPE cat
190: WHERE cat.cal_type = cp_cal_type;
191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs
197: WHERE ci.cal_status= cs.cal_status AND

Line 195: FROM IGS_CA_INST ci,

191: CURSOR c_cal_instance (
192: cp_cal_type IGS_CA_INST.cal_type%TYPE,
193: cp_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
194: SELECT cs.s_cal_status
195: FROM IGS_CA_INST ci,
196: IGS_CA_STAT cs
197: WHERE ci.cal_status= cs.cal_status AND
198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;

Line 201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,

197: WHERE ci.cal_status= cs.cal_status AND
198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'

Line 202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,

198: ci.cal_type = cp_cal_type AND
199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir

Line 203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,

199: ci.sequence_number = cp_sequence_number;
200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
207: WHERE cir.sup_cal_type =cp_acad_cal_type AND

Line 204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS

200: CURSOR c_cal_ins_rel (
201: cp_acad_cal_type IGS_CA_INST.cal_type%TYPE,
202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
207: WHERE cir.sup_cal_type =cp_acad_cal_type AND
208: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND

Line 206: FROM IGS_CA_INST_REL cir

202: cp_acad_ci_sequence_number IGS_CA_INST.sequence_number%TYPE,
203: cp_adm_cal_type IGS_CA_INST.cal_type%TYPE,
204: cp_adm_ci_sequence_number IGS_CA_INST.sequence_number%TYPE) IS
205: SELECT 'x'
206: FROM IGS_CA_INST_REL cir
207: WHERE cir.sup_cal_type =cp_acad_cal_type AND
208: cir.sup_ci_sequence_number = cp_acad_ci_sequence_number AND
209: cir.sub_cal_type = cp_adm_cal_type AND
210: cir.sub_ci_sequence_number = cp_adm_ci_sequence_number;