APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_UNT_OFR_OPT_N

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

Line 2719: FROM IGS_PS_UNT_OFR_OPT_N USEC

2715: p_n_uoo_id IN NUMBER,
2716: p_c_dfn_lvl OUT NOCOPY VARCHAR2) IS
2717: CURSOR c_usec (cp_n_uoo_id IN NUMBER) IS
2718: SELECT 1
2719: FROM IGS_PS_UNT_OFR_OPT_N USEC
2720: WHERE USEC.UOO_ID = cp_n_uoo_id
2721: AND ROWNUM < 2 ;
2722:
2723: CURSOR c_uop (cp_n_uoo_id IN NUMBER) IS