APPS.IGS_RE_GEN_002 dependencies on IGS_PR_MS_STAT

Line 1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;

1398: v_acai_sequence_number IGS_RE_CANDIDATURE.acai_sequence_number%TYPE;
1399: v_crv_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE;
1400: v_attendance_type IGS_EN_STDNT_PS_ATT.attendance_type%TYPE;
1401: v_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE;
1402: v_milestone_status IGS_PR_MS_STAT.milestone_status%TYPE;
1403: v_milestone_type IGS_RE_DFLT_MS_SET.milestone_type%TYPE;
1404: v_offset_days IGS_RE_DFLT_MS_SET.offset_days%TYPE;
1405: v_mil_sequence_number IGS_PR_MILESTONE.sequence_number%TYPE;
1406: v_commencement_dt DATE;

Line 1447: FROM IGS_PR_MS_STAT mst

1443: acai.nominated_course_cd = cp_acai_nominated_course_cd AND
1444: acai.sequence_number = cp_acai_sequence_number;
1445: CURSOR c_mst_planned IS
1446: SELECT mst.milestone_status
1447: FROM IGS_PR_MS_STAT mst
1448: WHERE mst.s_milestone_status = cst_planned
1449: AND mst.closed_ind = 'N'
1450: ORDER BY mst.milestone_status;
1451: CURSOR c_dms (