APPS.IGS_PR_GEN_006 dependencies on IGS_PS_VER

Line 149: IGS_PS_VER crv,

145: SELECT crv.course_type,
146: cow.org_unit_cd,
147: cow.ou_start_dt
148: FROM IGS_EN_STDNT_PS_ATT sca,
149: IGS_PS_VER crv,
150: IGS_PS_OWN cow
151: WHERE sca.person_id = p_person_id AND
152: sca.course_cd = p_course_cd AND
153: (sca.version_number = p_version_number OR

Line 167: cp_cow_ou_start_dt IGS_PS_VER.start_dt%TYPE,

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
171: WHERE our.parent_org_unit_cd = p_org_unit_cd AND

Line 168: cp_course_type IGS_PS_VER.course_type%TYPE) IS

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
171: WHERE our.parent_org_unit_cd = p_org_unit_cd AND
172: our.parent_start_dt = p_ou_start_dt AND