APPS.IGS_PR_GEN_006 dependencies on IGS_OR_UNIT

Line 166: cp_cow_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,

162: crv.version_number = cow.version_number AND
163: (crv.course_type = p_course_type OR
164: p_course_type IS NULL);
165: CURSOR c_our (
166: cp_cow_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
167: cp_cow_ou_start_dt IGS_PS_VER.start_dt%TYPE,
168: cp_course_type IGS_PS_VER.course_type%TYPE) IS
169: SELECT 'X'
170: FROM IGS_OR_UNIT_REL our

Line 170: FROM IGS_OR_UNIT_REL our

166: cp_cow_org_unit_cd IGS_OR_UNIT.org_unit_cd%TYPE,
167: cp_cow_ou_start_dt IGS_PS_VER.start_dt%TYPE,
168: cp_course_type IGS_PS_VER.course_type%TYPE) IS
169: SELECT 'X'
170: FROM IGS_OR_UNIT_REL our
171: WHERE our.parent_org_unit_cd = p_org_unit_cd AND
172: our.parent_start_dt = p_ou_start_dt AND
173: our.child_org_unit_cd = cp_cow_org_unit_cd AND
174: our.child_start_dt = cp_cow_ou_start_dt AND