APPS.IGF_SP_ASSIGN_PUB dependencies on IGS_CA_STAT

Line 159: cp_c_cal_status igs_ca_stat.cal_status%TYPE)

155: ******************************************************************************/
156:
157: CURSOR cur_check_ci_status(cp_c_cal_type igs_ca_inst.cal_type%TYPE,
158: cp_n_sequence_number igs_ca_inst.sequence_number%TYPE,
159: cp_c_cal_status igs_ca_stat.cal_status%TYPE)
160: IS
161: SELECT 'x'
162: FROM igs_ca_inst i,
163: igs_ca_stat s,

Line 163: igs_ca_stat s,

159: cp_c_cal_status igs_ca_stat.cal_status%TYPE)
160: IS
161: SELECT 'x'
162: FROM igs_ca_inst i,
163: igs_ca_stat s,
164: igf_ap_batch_aw_map b
165: WHERE i.cal_status = s.cal_status AND
166: i.cal_type = b.ci_cal_type AND
167: i.sequence_number = b.ci_sequence_number AND

Line 197: cp_c_cal_status igs_ca_stat.cal_status%TYPE,

193: Who When What
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'

Line 207: igs_ca_stat status

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
210: rel.sub_cal_type=ld.cal_type AND
211: rel.sub_ci_sequence_number=ld.sequence_number AND