APPS.IGF_SP_ASSIGN_PUB dependencies on IGS_CA_TYPE

Line 198: cp_c_awd_cal_cat igs_ca_type.s_cal_cat%TYPE,

194: ******************************************************************************/
195: CURSOR cur_check_ci_status (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
196: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
197: cp_c_cal_status igs_ca_stat.cal_status%TYPE,
198: cp_c_awd_cal_cat igs_ca_type.s_cal_cat%TYPE,
199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)
200: IS
201: SELECT 'x'
202: FROM igs_ca_inst aw,

Line 199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)

195: CURSOR cur_check_ci_status (cp_c_cal_type igs_ca_inst.cal_type%TYPE,
196: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
197: cp_c_cal_status igs_ca_stat.cal_status%TYPE,
198: cp_c_awd_cal_cat igs_ca_type.s_cal_cat%TYPE,
199: cp_c_ld_cal_cat igs_ca_type.s_cal_cat%TYPE)
200: IS
201: SELECT 'x'
202: FROM igs_ca_inst aw,
203: igs_ca_inst ld,

Line 204: igs_ca_type ld_t,

200: IS
201: SELECT 'x'
202: FROM igs_ca_inst aw,
203: igs_ca_inst ld,
204: igs_ca_type ld_t,
205: igs_ca_type aw_t,
206: igs_ca_inst_rel rel,
207: igs_ca_stat status
208: WHERE rel.sup_cal_type=aw.cal_type AND

Line 205: igs_ca_type aw_t,

201: SELECT 'x'
202: FROM igs_ca_inst aw,
203: igs_ca_inst ld,
204: igs_ca_type ld_t,
205: igs_ca_type aw_t,
206: igs_ca_inst_rel rel,
207: igs_ca_stat status
208: WHERE rel.sup_cal_type=aw.cal_type AND
209: rel.sup_ci_sequence_number=aw.sequence_number AND