APPS.IGS_GE_VAL_PARAM dependencies on IGS_PS_VER

Line 665: FUNCTION repp_val_course( p_course_cd IN OUT NOCOPY IGS_PS_VER_ALL.course_cd%TYPE,

661: -- MODIFICATION HISTORY
662: -- Person Date Comments
663: -- --------- -------- ------------------------------------------
664: -- MSONTER 21/08/98 Initial creation of function
665: FUNCTION repp_val_course( p_course_cd IN OUT NOCOPY IGS_PS_VER_ALL.course_cd%TYPE,
666: p_msg_name OUT NOCOPY VARCHAR2)
667: RETURN BOOLEAN
668: AS
669: --

Line 671: CURSOR c_cv(cp_course_cd IGS_PS_VER.course_cd%TYPE)

667: RETURN BOOLEAN
668: AS
669: --
670: -- Local Cursors
671: CURSOR c_cv(cp_course_cd IGS_PS_VER.course_cd%TYPE)
672: IS
673: SELECT 'x'
674: FROM IGS_PS_VER cv,
675: IGS_PS_STAT cs

Line 674: FROM IGS_PS_VER cv,

670: -- Local Cursors
671: CURSOR c_cv(cp_course_cd IGS_PS_VER.course_cd%TYPE)
672: IS
673: SELECT 'x'
674: FROM IGS_PS_VER cv,
675: IGS_PS_STAT cs
676: WHERE course_cd LIKE cp_course_cd
677: AND cs.course_status = cv.course_status
678: AND cs.s_course_status = 'ACTIVE';