APPS.IGS_PS_GEN_003 dependencies on IGS_CA_INST_ALL

Line 1043: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b, igs_ca_inst_all c

1039: AND uoo_id = p_n_uoo_id;
1040:
1041: CURSOR c_occur(cp_unit_section_occurrence_id igs_ps_usec_occurs_all.unit_section_occurrence_id%TYPE) IS
1042: SELECT b.occurrence_identifier,a.unit_cd,a.version_number,a.location_cd,a.unit_class,c.alternate_code
1043: FROM igs_ps_unit_ofr_opt_all a, igs_ps_usec_occurs_all b, igs_ca_inst_all c
1044: WHERE a.uoo_id=b.uoo_id
1045: AND b.unit_section_occurrence_id=cp_unit_section_occurrence_id
1046: AND a.cal_type=c.cal_type
1047: AND a.ci_sequence_number=c.sequence_number;