APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_UNIT_SUBTITLE

Line 1273: CURSOR unit_sub(cp_subtitle_id igs_ps_unit_subtitle.subtitle_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
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;

Line 1275: FROM igs_ps_unit_subtitle usub

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
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;

Line 1279: l_unit_subtitle igs_ps_unit_subtitle.subtitle%TYPE;

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
1283: -- Set the Derived scheduler Type