APPS.IGS_SS_ENR_DETAILS dependencies on IGS_GE_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 497: from igs_ge_note a,igs_ps_unt_ofr_opt_n b

493: cursor c_usec_note is
494: select
495: a.note_text,
496: b.crs_note_type
497: from igs_ge_note a,igs_ps_unt_ofr_opt_n b
498: where a.reference_number = b.reference_number
499: and b.uoo_id = p_uoo_id
500: order by crs_note_type ;
501: begin