DBA Data[Home] [Help]

APPS.IGS_EN_ADD_UNITS_API dependencies on IGS_CA_INST_ALL

Line 2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca

2757: -- cursor to get the unit details
2758: CURSOR c_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
2759: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
2760: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
2761: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
2762: WHERE ofr.uoo_id = cp_uoo_id
2763: AND ofr.cal_type = ca.cal_type
2764: AND ofr.ci_sequence_number = ca.sequence_number;
2765:

Line 3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca

3300: -- cursor to fetch the unit details
3301: CURSOR c_get_unit_dtls (cp_uoo_id igs_en_su_attempt.uoo_id%TYPE) IS
3302: SELECT ofr.unit_cd, ofr.version_number, ofr.cal_type, ofr.ci_sequence_number,
3303: ofr.location_cd, ofr.unit_class, ca.start_dt, ca.end_dt
3304: FROM igs_ps_unit_ofr_opt ofr, igs_ca_inst_all ca
3305: WHERE ofr.uoo_id = cp_uoo_id
3306: AND ofr.cal_type = ca.cal_type
3307: AND ofr.ci_sequence_number = ca.sequence_number;
3308: