APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_PS_USEC_REF

Line 1153: FROM igs_ps_usec_ref

1149:
1150: -- added by ckasu as a part of bug# 4642089
1151: CURSOR c_sua_chg_alwd IS
1152: SELECT NVL(subtitle_modifiable_flag,'N')
1153: FROM igs_ps_usec_ref
1154: WHERE uoo_id = p_uoo_id;
1155:
1156: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;
1157: l_auditable_ind igs_ps_unit_ver.auditable_ind%TYPE := NULL ;

Line 1156: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;

1152: SELECT NVL(subtitle_modifiable_flag,'N')
1153: FROM igs_ps_usec_ref
1154: WHERE uoo_id = p_uoo_id;
1155:
1156: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;
1157: l_auditable_ind igs_ps_unit_ver.auditable_ind%TYPE := NULL ;
1158: l_version_number igs_as_grd_sch_grade.version_number%TYPE := 0 ;
1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;
1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;