APPS.IGS_EN_GEN_012 dependencies on IGS_PE_PERS_UNT_EXCL

Line 141: FROM IGS_PE_PERS_UNT_EXCL PUE,

137: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
138: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
139: SELECT PUE.ROWID,
140: PUE.*
141: FROM IGS_PE_PERS_UNT_EXCL PUE,
142: IGS_PE_PERSENC_EFFCT PEE
143: WHERE PUE.person_id = cp_person_id AND
144: PUE.encumbrance_type = cp_encumbrance_type AND
145: PUE.pen_start_dt = cp_start_dt AND

Line 334: -- SELECTING ALL IGS_PE_PERS_UNT_EXCL RECORDS

330:
331:
332: END IF;
333: END LOOP;
334: -- SELECTING ALL IGS_PE_PERS_UNT_EXCL RECORDS
335: FOR v_psn_unit_excl_rec IN c_psn_unit_excl(p_person_id,
336: p_encumbrance_type,
337: p_start_dt,
338: p_expiry_dt) LOOP

Line 339: -- for each IGS_PE_PERS_UNT_EXCL record returned,

335: FOR v_psn_unit_excl_rec IN c_psn_unit_excl(p_person_id,
336: p_encumbrance_type,
337: p_start_dt,
338: p_expiry_dt) LOOP
339: -- for each IGS_PE_PERS_UNT_EXCL record returned,
340: -- update the expiry_dt
341: IF (v_psn_unit_excl_rec.pue_start_dt > p_expiry_dt) THEN
342:
343: Igs_Pe_Pers_Unt_Excl_Pkg.UPDATE_ROW(

Line 343: Igs_Pe_Pers_Unt_Excl_Pkg.UPDATE_ROW(

339: -- for each IGS_PE_PERS_UNT_EXCL record returned,
340: -- update the expiry_dt
341: IF (v_psn_unit_excl_rec.pue_start_dt > p_expiry_dt) THEN
342:
343: Igs_Pe_Pers_Unt_Excl_Pkg.UPDATE_ROW(
344: X_ROWID => v_psn_unit_excl_rec.ROWID ,
345: X_PERSON_ID => v_psn_unit_excl_rec.PERSON_ID ,
346: X_ENCUMBRANCE_TYPE => v_psn_unit_excl_rec.ENCUMBRANCE_TYPE ,
347: X_PEN_START_DT => v_psn_unit_excl_rec.PEN_START_DT ,

Line 359: Igs_Pe_Pers_Unt_Excl_Pkg.UPDATE_ROW(

355: );
356:
357:
358: ELSE
359: Igs_Pe_Pers_Unt_Excl_Pkg.UPDATE_ROW(
360: X_ROWID => v_psn_unit_excl_rec.ROWID ,
361: X_PERSON_ID => v_psn_unit_excl_rec.PERSON_ID ,
362: X_ENCUMBRANCE_TYPE => v_psn_unit_excl_rec.ENCUMBRANCE_TYPE ,
363: X_PEN_START_DT => v_psn_unit_excl_rec.PEN_START_DT ,