APPS.IGS_PR_GEN_001 dependencies on IGS_OR_UNIT

Line 173: cp_cow_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,

169: crv.version_number = p_version_number AND
170: crv.course_cd = cow.course_cd AND
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

Line 174: cp_cow_ou_start_dt IGS_OR_UNIT.start_dt%TYPE,

170: crv.course_cd = cow.course_cd AND
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

Line 177: FROM IGS_OR_UNIT_REL 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
180: our.child_org_unit_cd = cp_cow_org_unit_cd AND
181: our.child_start_dt = cp_cow_ou_start_dt AND