APPS.IGS_PS_GEN_004 dependencies on IGS_PS_VER

Line 55: cp_course_cd IGS_PS_VER.course_cd%TYPE,

51: p_restricted_ind IN VARCHAR2 )
52: AS
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

Line 56: cp_version_number IGS_PS_VER.version_number%TYPE) IS

52: AS
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

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 59: WHERE IGS_PS_VER.course_cd = cp_course_cd AND

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';
63: v_course_status IGS_PS_STAT.s_course_status%TYPE;

Line 60: IGS_PS_VER.version_number = cp_version_number AND

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';
63: v_course_status IGS_PS_STAT.s_course_status%TYPE;
64: x_rowid VARCHAR2(25);

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