DBA Data[Home] [Help]

APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNITREQREF_CD

Line 381: FROM igs_ps_unitreqref_cd unitref,

377: ORDER BY 1 ;
378:
379: CURSOR c_unit_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
380: SELECT unitref.REFERENCE_CODE || ' - ' || unitref.REFERENCE_CODE_DESC ref_cd
381: FROM igs_ps_unitreqref_cd unitref,
382: igs_ps_unit_ofr_opt uoo
383: WHERE uoo.uoo_id = cp_uoo_id
384: AND uoo.unit_cd = unitref.unit_cd
385: AND uoo.version_number = unitref.version_number

Line 5084: FROM igs_ps_unitreqref_cd

5080: AND ROWNUM < 2;
5081:
5082: CURSOR c_uv_req_ref(cp_c_unit_cd IN VARCHAR2, cp_n_version IN NUMBER) IS
5083: SELECT 1
5084: FROM igs_ps_unitreqref_cd
5085: WHERE unit_cd = cp_c_unit_cd
5086: AND version_number = cp_n_version
5087: AND ROWNUM <2 ;
5088: