APPS.IGS_PS_GEN_004 dependencies on IGS_PS_STAT

Line 57: SELECT IGS_PS_STAT.s_course_status

53:
54: CURSOR c_course_status(
55: cp_course_cd IGS_PS_VER.course_cd%TYPE,
56: cp_version_number IGS_PS_VER.version_number%TYPE) IS
57: SELECT IGS_PS_STAT.s_course_status
58: FROM IGS_PS_STAT,IGS_PS_VER
59: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
60: IGS_PS_VER.version_number = cp_version_number AND
61: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;

Line 58: FROM IGS_PS_STAT,IGS_PS_VER

54: CURSOR c_course_status(
55: cp_course_cd IGS_PS_VER.course_cd%TYPE,
56: cp_version_number IGS_PS_VER.version_number%TYPE) IS
57: SELECT IGS_PS_STAT.s_course_status
58: FROM IGS_PS_STAT,IGS_PS_VER
59: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
60: IGS_PS_VER.version_number = cp_version_number AND
61: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
62: cst_active CONSTANT VARCHAR2(8) DEFAULT 'ACTIVE';

Line 61: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;

57: SELECT IGS_PS_STAT.s_course_status
58: FROM IGS_PS_STAT,IGS_PS_VER
59: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
60: IGS_PS_VER.version_number = cp_version_number AND
61: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
62: cst_active CONSTANT VARCHAR2(8) DEFAULT 'ACTIVE';
63: v_course_status IGS_PS_STAT.s_course_status%TYPE;
64: x_rowid VARCHAR2(25);
65: l_org_id NUMBER(15);

Line 63: v_course_status IGS_PS_STAT.s_course_status%TYPE;

59: WHERE IGS_PS_VER.course_cd = cp_course_cd AND
60: IGS_PS_VER.version_number = cp_version_number AND
61: IGS_PS_STAT.course_status = IGS_PS_VER.course_status;
62: cst_active CONSTANT VARCHAR2(8) DEFAULT 'ACTIVE';
63: v_course_status IGS_PS_STAT.s_course_status%TYPE;
64: x_rowid VARCHAR2(25);
65: l_org_id NUMBER(15);
66:
67: BEGIN