APPS.IGS_PS_GEN_006 dependencies on IGS_PS_UNIT_SUBTITLE

Line 1143: v_subtitle IGS_PS_UNIT_SUBTITLE.SUBTITLE%TYPE;

1139: v_ou_description IGS_OR_UNIT.description%TYPE;
1140: v_uicl_description IGS_PS_UNIT_INT_LVL.description%TYPE;
1141: v_level_code IGS_PS_UNIT_TYPE_LVL.LEVEL_CODE%TYPE;
1142: v_repeat_code IGS_PS_RPT_FMLY_ALL.REPEAT_CODE%TYPE;
1143: v_subtitle IGS_PS_UNIT_SUBTITLE.SUBTITLE%TYPE;
1144:
1145: CURSOR c_unit_level(
1146: cp_unit_level IGS_PS_UNIT_LEVEL.unit_level%TYPE) IS
1147: SELECT description

Line 1174: CURSOR c_unit_subtitle ( cp_subtitle_id IGS_PS_UNIT_SUBTITLE.SUBTITLE_ID%TYPE ) IS

1170: SELECT repeat_code
1171: FROM IGS_PS_RPT_FMLY_ALL
1172: WHERE RPT_FMLY_ID= cp_rpt_fmly_id;
1173:
1174: CURSOR c_unit_subtitle ( cp_subtitle_id IGS_PS_UNIT_SUBTITLE.SUBTITLE_ID%TYPE ) IS
1175: SELECT subtitle
1176: FROM igs_ps_unit_subtitle
1177: WHERE subtitle_id = cp_subtitle_id;
1178:

Line 1176: FROM igs_ps_unit_subtitle

1172: WHERE RPT_FMLY_ID= cp_rpt_fmly_id;
1173:
1174: CURSOR c_unit_subtitle ( cp_subtitle_id IGS_PS_UNIT_SUBTITLE.SUBTITLE_ID%TYPE ) IS
1175: SELECT subtitle
1176: FROM igs_ps_unit_subtitle
1177: WHERE subtitle_id = cp_subtitle_id;
1178:
1179: x_rowid VARCHAR2(25);
1180: l_org_id NUMBER(15);