APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_UNIT_FACILITY_V

Line 401: FROM igs_ps_unit_facility_v

397:
398: CURSOR c_fac(cp_unit_cd IN VARCHAR2,
399: cp_version_number IN NUMBER) IS
400: SELECT *
401: FROM igs_ps_unit_facility_v
402: WHERE unit_code=cp_unit_cd
403: AND unit_version_number=cp_version_number;
404:
405: BEGIN

Line 941: igs_ps_unit_facility_v c

937: SELECT media_code,
938: media_description
939: FROM igs_ps_usec_occurs_all a,
940: igs_ps_unit_ofr_opt_all b,
941: igs_ps_unit_facility_v c
942: WHERE a.unit_section_occurrence_id = l_usec_id
943: AND a.uoo_id=b.uoo_id
944: AND b.unit_cd=c.unit_code
945: AND b.version_number=c.unit_version_number;