APPS.IGS_SS_ENR_DETAILS dependencies on IGS_PS_USEC_REF

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 562: igs_ps_usec_ref uref,

558: SELECT
559: uref.title,
560: usub.subtitle
561: FROM
562: igs_ps_usec_ref uref,
563: igs_ps_unit_subtitle usub
564: WHERE
565: uref.uoo_id = p_uoo_id AND
566: uref.subtitle_id = usub.subtitle_id(+);

Line 675: igs_ps_usec_ref uref,

671: SELECT
672: uref.title,
673: usub.subtitle
674: FROM
675: igs_ps_usec_ref uref,
676: igs_ps_unit_subtitle usub
677: WHERE
678: uref.uoo_id = p_uoo_id AND
679: uref.subtitle_id = usub.subtitle_id(+);

Line 760: igs_ps_usec_ref uref,

756: SELECT
757: uref.title,
758: usub.subtitle
759: FROM
760: igs_ps_usec_ref uref,
761: igs_ps_unit_subtitle usub
762: WHERE
763: uref.uoo_id = p_uoo_id AND
764: uref.subtitle_id = usub.subtitle_id(+);

Line 1325: FROM igs_ps_usec_ref

1321: p_uoo_id IN NUMBER
1322: ) RETURN CHAR IS
1323: CURSOR c_sua_chg_alwd IS
1324: SELECT NVL(subtitle_modifiable_flag,'N')
1325: FROM igs_ps_usec_ref
1326: WHERE
1327: uoo_id = p_uoo_id;
1328:
1329: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;

Line 1329: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;

1325: FROM igs_ps_usec_ref
1326: WHERE
1327: uoo_id = p_uoo_id;
1328:
1329: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;
1330:
1331: BEGIN
1332:
1333: OPEN c_sua_chg_alwd;

Line 3392: FROM igs_ps_usec_ref t

3388: FUNCTION get_us_title(p_n_uoo_id IN NUMBER) RETURN VARCHAR2 IS
3389:
3390: CURSOR c_us_title(cp_n_uoo_id IN NUMBER) IS
3391: SELECT t.title
3392: FROM igs_ps_usec_ref t
3393: WHERE t.uoo_id = cp_n_uoo_id;
3394:
3395: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS
3396: SELECT uv.title

Line 4460: igs_ps_usec_ref us

4456: IS
4457: CURSOR c_us_title(cp_n_uoo_id IN NUMBER) IS
4458: SELECT t.subtitle
4459: FROM igs_ps_unit_subtitle t,
4460: igs_ps_usec_ref us
4461: WHERE us.uoo_id = cp_n_uoo_id
4462: AND us.subtitle_id = t.subtitle_id;
4463:
4464: CURSOR c_uv_title(cp_n_uoo_id IN NUMBER) IS

Line 5052: FROM igs_ps_usec_ref

5048: -------------------------------------------------------------------
5049: IS
5050: CURSOR c_ref_id (cp_n_uoo_id IN NUMBER) IS
5051: SELECT unit_section_reference_id
5052: FROM igs_ps_usec_ref
5053: WHERE uoo_id = cp_n_uoo_id;
5054: rec_ref_id c_ref_id%ROWTYPE;
5055:
5056: CURSOR c_us_gen_ref (cp_n_ref_id IN NUMBER) IS

Line 5058: FROM igs_ps_usec_ref_cd

5054: rec_ref_id c_ref_id%ROWTYPE;
5055:
5056: CURSOR c_us_gen_ref (cp_n_ref_id IN NUMBER) IS
5057: SELECT 1
5058: FROM igs_ps_usec_ref_cd
5059: WHERE unit_section_reference_id =cp_n_ref_id
5060: AND ROWNUM <2;
5061:
5062: CURSOR c_us_req_ref (cp_n_ref_id IN NUMBER) IS