APPS.IGS_FI_PRC_STDNT_DPSTS dependencies on IGS_PS_VER

Line 57: TYPE stdnt_sca_tab IS TABLE OF igs_ps_ver.course_cd%TYPE

53:
54: do_nothing EXCEPTION;
55:
56: -- Pl/SQL table for storing all Student Program Attempts
57: TYPE stdnt_sca_tab IS TABLE OF igs_ps_ver.course_cd%TYPE
58: INDEX BY BINARY_INTEGER;
59:
60: -- Pl/SQL table for storing all Student Program Attempts Version Numbers
61: TYPE stdnt_sca_ver_num_tab IS TABLE OF igs_ps_ver.version_number%TYPE

Line 61: TYPE stdnt_sca_ver_num_tab IS TABLE OF igs_ps_ver.version_number%TYPE

57: TYPE stdnt_sca_tab IS TABLE OF igs_ps_ver.course_cd%TYPE
58: INDEX BY BINARY_INTEGER;
59:
60: -- Pl/SQL table for storing all Student Program Attempts Version Numbers
61: TYPE stdnt_sca_ver_num_tab IS TABLE OF igs_ps_ver.version_number%TYPE
62: INDEX BY BINARY_INTEGER;
63:
64: -- Pl/SQL table for storing all Student Program Attempts Program Types
65: TYPE stdnt_sca_typ_tab IS TABLE OF igs_ps_ver.course_type%TYPE

Line 65: TYPE stdnt_sca_typ_tab IS TABLE OF igs_ps_ver.course_type%TYPE

61: TYPE stdnt_sca_ver_num_tab IS TABLE OF igs_ps_ver.version_number%TYPE
62: INDEX BY BINARY_INTEGER;
63:
64: -- Pl/SQL table for storing all Student Program Attempts Program Types
65: TYPE stdnt_sca_typ_tab IS TABLE OF igs_ps_ver.course_type%TYPE
66: INDEX BY BINARY_INTEGER;
67:
68: -- Pl/SQL table for storing all Student Program Attempts Statuses
69: TYPE stdnt_sca_status_tab IS TABLE OF igs_en_stdnt_ps_att.course_attempt_status%TYPE

Line 171: igs_ps_ver ps

167: spa.version_number version_number,
168: ps.course_type course_type,
169: spa.course_attempt_status course_attempt_status
170: FROM igs_en_stdnt_ps_att spa,
171: igs_ps_ver ps
172: WHERE spa.course_cd = ps.course_cd AND
173: spa.version_number = ps.version_number AND
174: spa.person_id = cp_n_person_id AND
175: (

Line 1096: igs_ps_ver ps,

1092: inst.crv_version_number version_number,
1093: ps.course_type course_type
1094: FROM igs_ad_ps_appl_inst inst,
1095: igs_ad_appl aa,
1096: igs_ps_ver ps,
1097: igs_ad_ofrdfrmt_stat df,
1098: igs_ad_ofr_resp_stat off
1099: WHERE inst.person_id = cp_n_person_id AND
1100: aa.person_id = inst.person_id AND