DBA Data[Home] [Help]

APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNIT_VER_NOTE

Line 468: from igs_ge_note a, igs_ps_unit_ver_note b

464: cursor c_unit_note is
465: select
466: a.note_text,
467: b.crs_note_type
468: from igs_ge_note a, igs_ps_unit_ver_note b
469: where a.reference_number = b.reference_number
470: and b.unit_cd = p_unit_cd
471: and b.version_number = p_version_number
472: order by crs_note_type ;

Line 2746: FROM IGS_PS_UNIT_VER_NOTE UV,

2742: AND ROWNUM < 2;
2743:
2744: CURSOR c_uv (cp_n_uoo_id IN NUMBER) IS
2745: SELECT 1
2746: FROM IGS_PS_UNIT_VER_NOTE UV,
2747: IGS_PS_UNIT_OFR_OPT_ALL UOO
2748: WHERE UOO.UNIT_CD = UV.UNIT_CD
2749: AND UOO.VERSION_NUMBER = UV.VERSION_NUMBER
2750: AND UOO.UOO_ID = cp_n_uoo_id