DBA Data[Home] [Help]

APPS.IGS_PR_GEN_001 dependencies on IGS_PS_VER

Line 166: FROM IGS_PS_VER crv,

162: CURSOR c_crv_cow IS
163: SELECT crv.course_type,
164: cow.org_unit_cd,
165: cow.ou_start_dt
166: FROM IGS_PS_VER crv,
167: IGS_PS_OWN cow
168: WHERE crv.course_cd = p_course_cd AND
169: crv.version_number = p_version_number AND
170: crv.course_cd = cow.course_cd AND

Line 175: cp_course_type IGS_PS_VER.course_type%TYPE) IS

171: crv.version_number = cow.version_number;
172: CURSOR c_our (
173: cp_cow_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
174: cp_cow_ou_start_dt IGS_OR_UNIT.start_dt%TYPE,
175: cp_course_type IGS_PS_VER.course_type%TYPE) IS
176: SELECT 'X'
177: FROM IGS_OR_UNIT_REL our
178: WHERE our.parent_org_unit_cd = p_org_unit_cd AND
179: our.parent_start_dt = p_ou_start_dt AND