APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_US_REQ_REF_CD

Line 374: FROM igs_ps_us_req_ref_cd a, igs_ps_usec_ref b

370: lv_ref_cd VARCHAR2(32000) ;
371:
372: CURSOR c_usec_ref_cd (cp_uoo_id IGS_PS_UNIT_OFR_OPT.UOO_ID%TYPE) IS
373: SELECT a.reference_code||' - '||a.reference_code_desc ref_cd
374: FROM igs_ps_us_req_ref_cd a, igs_ps_usec_ref b
375: WHERE b.uoo_id = cp_uoo_id
376: AND a.unit_section_reference_id = b.unit_section_reference_id
377: ORDER BY 1 ;
378:

Line 5064: FROM igs_ps_us_req_ref_cd

5060: AND ROWNUM <2;
5061:
5062: CURSOR c_us_req_ref (cp_n_ref_id IN NUMBER) IS
5063: SELECT 1
5064: FROM igs_ps_us_req_ref_cd
5065: WHERE unit_section_reference_id =cp_n_ref_id
5066: AND ROWNUM <2;
5067:
5068: CURSOR c_uv(cp_n_uoo_id IN NUMBER) IS