eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_IN_GEN_001 dependencies on IGS_PE_PERSENC_EFFCT

Line 90: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_SRVC';

86: -- level calls.
87: DECLARE
88: cst_academic CONSTANT IGS_FI_ENCMB_TYPE.s_encumbrance_cat%TYPE := 'ACADEMIC';
89: cst_sus_srvc CONSTANT
90: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_SRVC';
91: cst_rvk_srvc CONSTANT
92: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RVK_SRVC';
93: cst_exc_course CONSTANT
94: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_COURSE';

Line 92: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RVK_SRVC';

88: cst_academic CONSTANT IGS_FI_ENCMB_TYPE.s_encumbrance_cat%TYPE := 'ACADEMIC';
89: cst_sus_srvc CONSTANT
90: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_SRVC';
91: cst_rvk_srvc CONSTANT
92: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RVK_SRVC';
93: cst_exc_course CONSTANT
94: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_COURSE';
95: cst_sus_course CONSTANT
96: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_COURSE';

Line 94: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_COURSE';

90: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_SRVC';
91: cst_rvk_srvc CONSTANT
92: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RVK_SRVC';
93: cst_exc_course CONSTANT
94: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_COURSE';
95: cst_sus_course CONSTANT
96: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_COURSE';
97: cst_exc_crs_gp CONSTANT
98: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_GP';

Line 96: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_COURSE';

92: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RVK_SRVC';
93: cst_exc_course CONSTANT
94: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_COURSE';
95: cst_sus_course CONSTANT
96: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_COURSE';
97: cst_exc_crs_gp CONSTANT
98: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_GP';
99: cst_exc_crs_u CONSTANT
100: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_U';

Line 98: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_GP';

94: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_COURSE';
95: cst_sus_course CONSTANT
96: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_COURSE';
97: cst_exc_crs_gp CONSTANT
98: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_GP';
99: cst_exc_crs_u CONSTANT
100: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_U';
101: cst_rqrd_crs_u CONSTANT
102: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RQRD_CRS_U';

Line 100: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_U';

96: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'SUS_COURSE';
97: cst_exc_crs_gp CONSTANT
98: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_GP';
99: cst_exc_crs_u CONSTANT
100: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_U';
101: cst_rqrd_crs_u CONSTANT
102: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RQRD_CRS_U';
103: cst_exc_crs_us CONSTANT
104: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_US';

Line 102: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RQRD_CRS_U';

98: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_GP';
99: cst_exc_crs_u CONSTANT
100: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_U';
101: cst_rqrd_crs_u CONSTANT
102: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RQRD_CRS_U';
103: cst_exc_crs_us CONSTANT
104: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_US';
105: cst_rstr_ge_cp CONSTANT
106: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_GE_CP';

Line 104: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_US';

100: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_U';
101: cst_rqrd_crs_u CONSTANT
102: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RQRD_CRS_U';
103: cst_exc_crs_us CONSTANT
104: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_US';
105: cst_rstr_ge_cp CONSTANT
106: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_GE_CP';
107: cst_rstr_le_cp CONSTANT
108: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_LE_CP';

Line 106: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_GE_CP';

102: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RQRD_CRS_U';
103: cst_exc_crs_us CONSTANT
104: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_US';
105: cst_rstr_ge_cp CONSTANT
106: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_GE_CP';
107: cst_rstr_le_cp CONSTANT
108: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_LE_CP';
109: cst_rstr_at_ty CONSTANT
110: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_AT_TY';

Line 108: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_LE_CP';

104: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'EXC_CRS_US';
105: cst_rstr_ge_cp CONSTANT
106: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_GE_CP';
107: cst_rstr_le_cp CONSTANT
108: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_LE_CP';
109: cst_rstr_at_ty CONSTANT
110: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_AT_TY';
111: cst_all CONSTANT VARCHAR2(10) := 'ALL';
112: cst_person CONSTANT VARCHAR2(10) := 'PERSON';

Line 110: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_AT_TY';

106: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_GE_CP';
107: cst_rstr_le_cp CONSTANT
108: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_LE_CP';
109: cst_rstr_at_ty CONSTANT
110: IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE := 'RSTR_AT_TY';
111: cst_all CONSTANT VARCHAR2(10) := 'ALL';
112: cst_person CONSTANT VARCHAR2(10) := 'PERSON';
113: cst_course CONSTANT VARCHAR2(10) := 'COURSE';
114: cst_enrolment CONSTANT VARCHAR2(10) := 'ENROLMENT';

Line 154: FROM IGS_PE_PERSENC_EFFCT pee

150: pee.pen_start_dt,
151: pee.s_encmb_effect_type,
152: pee.pee_start_dt,
153: pee.sequence_number
154: FROM IGS_PE_PERSENC_EFFCT pee
155: WHERE -- child of current pen record
156: pee.person_id = cp_person_id AND
157: pee.encumbrance_type = cp_encumbrance_type AND
158: pee.pen_start_dt = cp_start_dt AND

Line 166: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,

162: (p_course_cd IS NULL OR
163: pee.course_cd IS NULL OR
164: pee.course_cd = p_course_cd);
165: CURSOR c_pce (
166: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

Line 167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

163: pee.course_cd IS NULL OR
164: pee.course_cd = p_course_cd);
165: CURSOR c_pce (
166: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
171: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

164: pee.course_cd = p_course_cd);
165: CURSOR c_pce (
166: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
171: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
172: SELECT 'X'

Line 169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

165: CURSOR c_pce (
166: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
171: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
172: SELECT 'X'
173: FROM IGS_PE_COURSE_EXCL pce

Line 170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

166: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
171: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
172: SELECT 'X'
173: FROM IGS_PE_COURSE_EXCL pce
174: WHERE -- child of current pee record

Line 171: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

167: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
168: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
169: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
170: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
171: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
172: SELECT 'X'
173: FROM IGS_PE_COURSE_EXCL pce
174: WHERE -- child of current pee record
175: pce.person_id = cp_person_id AND

Line 186: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,

182: (pce.expiry_dt IS NULL OR
183: pce.expiry_dt > p_effective_dt) AND
184: pce.course_cd = p_course_cd;
185: CURSOR c_pcge (
186: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

Line 187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

183: pce.expiry_dt > p_effective_dt) AND
184: pce.course_cd = p_course_cd;
185: CURSOR c_pcge (
186: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
191: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

184: pce.course_cd = p_course_cd;
185: CURSOR c_pcge (
186: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
191: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
192: SELECT 'X'

Line 189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

185: CURSOR c_pcge (
186: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
191: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
192: SELECT 'X'
193: FROM IGS_PE_CRS_GRP_EXCL pcge

Line 190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

186: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
191: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
192: SELECT 'X'
193: FROM IGS_PE_CRS_GRP_EXCL pcge
194: WHERE -- child of current pee record

Line 191: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

187: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
188: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
189: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
190: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
191: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
192: SELECT 'X'
193: FROM IGS_PE_CRS_GRP_EXCL pcge
194: WHERE -- child of current pee record
195: pcge.person_id = cp_person_id AND

Line 210: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,

206: FROM IGS_PS_GRP_MBR cgm
207: WHERE cgm.course_group_cd = pcge.course_group_cd AND
208: cgm.course_cd = p_course_cd);
209: CURSOR c_pue (
210: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

Line 211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

207: WHERE cgm.course_group_cd = pcge.course_group_cd AND
208: cgm.course_cd = p_course_cd);
209: CURSOR c_pue (
210: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
215: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

208: cgm.course_cd = p_course_cd);
209: CURSOR c_pue (
210: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
215: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
216: SELECT 'X'

Line 213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

209: CURSOR c_pue (
210: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
215: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
216: SELECT 'X'
217: FROM IGS_PE_PERS_UNT_EXCL pue

Line 214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

210: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
215: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
216: SELECT 'X'
217: FROM IGS_PE_PERS_UNT_EXCL pue
218: WHERE -- child of current pee record

Line 215: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

211: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
212: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
213: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
214: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
215: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
216: SELECT 'X'
217: FROM IGS_PE_PERS_UNT_EXCL pue
218: WHERE -- child of current pee record
219: pue.person_id = cp_person_id AND

Line 229: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,

225: pue.pue_start_dt <= p_effective_dt AND
226: (pue.expiry_dt IS NULL OR
227: pue.expiry_dt > p_effective_dt);
228: CURSOR c_pur (
229: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

Line 230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

226: (pue.expiry_dt IS NULL OR
227: pue.expiry_dt > p_effective_dt);
228: CURSOR c_pur (
229: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
234: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

227: pue.expiry_dt > p_effective_dt);
228: CURSOR c_pur (
229: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
234: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
235: SELECT 'X'

Line 232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

228: CURSOR c_pur (
229: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
234: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
235: SELECT 'X'
236: FROM IGS_PE_UNT_REQUIRMNT pur

Line 233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

229: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
234: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
235: SELECT 'X'
236: FROM IGS_PE_UNT_REQUIRMNT pur
237: WHERE -- child of current pee record

Line 234: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

230: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
231: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
232: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
233: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
234: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
235: SELECT 'X'
236: FROM IGS_PE_UNT_REQUIRMNT pur
237: WHERE -- child of current pee record
238: pur.person_id = cp_person_id AND

Line 248: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,

244: pur.pur_start_dt <= p_effective_dt AND
245: (pur.expiry_dt IS NULL OR
246: pur.expiry_dt > p_effective_dt);
247: CURSOR c_puse (
248: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

Line 249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,

245: (pur.expiry_dt IS NULL OR
246: pur.expiry_dt > p_effective_dt);
247: CURSOR c_puse (
248: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
253: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

Line 250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,

246: pur.expiry_dt > p_effective_dt);
247: CURSOR c_puse (
248: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
253: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
254: SELECT 'X'

Line 251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,

247: CURSOR c_puse (
248: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
253: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
254: SELECT 'X'
255: FROM IGS_PE_UNT_SET_EXCL puse

Line 252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,

248: cp_person_id IGS_PE_PERSENC_EFFCT.person_id%TYPE,
249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
253: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
254: SELECT 'X'
255: FROM IGS_PE_UNT_SET_EXCL puse
256: WHERE -- child of current pee record

Line 253: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS

249: cp_encumbrance_type IGS_PE_PERSENC_EFFCT.encumbrance_type%TYPE,
250: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
251: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
252: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
253: cp_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
254: SELECT 'X'
255: FROM IGS_PE_UNT_SET_EXCL puse
256: WHERE -- child of current pee record
257: puse.person_id = cp_person_id AND