APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_USEC_REF_V

Line 1268: CURSOR usec_ref(cp_uoo_id igs_ps_usec_ref_v.uoo_id%TYPE) IS

1264:
1265: l_o_count NUMBER;
1266: l_trans_type VARCHAR2(30);
1267:
1268: CURSOR usec_ref(cp_uoo_id igs_ps_usec_ref_v.uoo_id%TYPE) IS
1269: SELECT ur.title, ur.subtitle
1270: FROM igs_ps_usec_ref_v ur
1271: WHERE ur.uoo_id = cp_uoo_id;
1272:

Line 1270: FROM igs_ps_usec_ref_v ur

1266: l_trans_type VARCHAR2(30);
1267:
1268: CURSOR usec_ref(cp_uoo_id igs_ps_usec_ref_v.uoo_id%TYPE) IS
1269: SELECT ur.title, ur.subtitle
1270: FROM igs_ps_usec_ref_v ur
1271: WHERE ur.uoo_id = cp_uoo_id;
1272:
1273: CURSOR unit_sub(cp_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE) IS
1274: SELECT usub.subtitle

Line 1277: l_usec_title igs_ps_usec_ref_v.title%TYPE;

1273: CURSOR unit_sub(cp_subtitle_id igs_ps_unit_subtitle.subtitle_id%TYPE) IS
1274: SELECT usub.subtitle
1275: FROM igs_ps_unit_subtitle usub
1276: WHERE usub.subtitle_id = cp_subtitle_id ;
1277: l_usec_title igs_ps_usec_ref_v.title%TYPE;
1278: l_usec_subtitle igs_ps_usec_ref_v.subtitle%TYPE;
1279: l_unit_subtitle igs_ps_unit_subtitle.subtitle%TYPE;
1280:
1281:

Line 1278: l_usec_subtitle igs_ps_usec_ref_v.subtitle%TYPE;

1274: SELECT usub.subtitle
1275: FROM igs_ps_unit_subtitle usub
1276: WHERE usub.subtitle_id = cp_subtitle_id ;
1277: l_usec_title igs_ps_usec_ref_v.title%TYPE;
1278: l_usec_subtitle igs_ps_usec_ref_v.subtitle%TYPE;
1279: l_unit_subtitle igs_ps_unit_subtitle.subtitle%TYPE;
1280:
1281:
1282: BEGIN