APPS.IGS_PR_GEN_005 dependencies on IGS_PS_VER

Line 192: FROM igs_ps_ver_ru

188: v_course_cd igs_en_stdnt_ps_att.course_cd%TYPE;
189: v_version_number igs_en_stdnt_ps_att.version_number%TYPE;
190: CURSOR c_cvr IS
191: SELECT igs_ru_gen_003.rulp_get_rule (rul_sequence_number)
192: FROM igs_ps_ver_ru
193: WHERE course_cd = v_course_cd
194: AND version_number = v_version_number
195: AND s_rule_call_cd = p_s_rule_call_cd;
196: CURSOR c_csr IS

Line 1417: igs_ps_ver crv,

1413: SELECT crv.course_type,
1414: cow.org_unit_cd,
1415: cow.ou_start_dt
1416: FROM igs_en_stdnt_ps_att sca,
1417: igs_ps_ver crv,
1418: igs_ps_own cow
1419: WHERE sca.person_id = p_person_id
1420: AND sca.course_cd = p_course_cd
1421: AND (sca.version_number = p_version_number

Line 1431: cp_course_type igs_ps_ver.course_type%TYPE

1427: AND crv.version_number = cow.version_number;
1428: CURSOR c_our (
1429: cp_cow_org_unit_cd igs_or_unit.org_unit_cd%TYPE,
1430: cp_cow_ou_start_dt igs_or_unit.start_dt%TYPE,
1431: cp_course_type igs_ps_ver.course_type%TYPE
1432: ) IS
1433: SELECT 'X'
1434: FROM igs_or_unit_rel our
1435: WHERE our.parent_org_unit_cd = p_org_unit_cd