APPS.IGS_EN_GEN_012 dependencies on IGS_PE_CRS_GRP_EXCL

Line 104: FROM IGS_PE_CRS_GRP_EXCL PCGE,

100: cp_encumbrance_type IGS_PE_PERS_ENCUMB.encumbrance_type%TYPE,
101: cp_start_dt IGS_PE_PERS_ENCUMB.start_dt%TYPE,
102: cp_expiry_dt IGS_PE_PERS_ENCUMB.expiry_dt%TYPE) IS
103: SELECT PCGE.ROWID, PCGE.*
104: FROM IGS_PE_CRS_GRP_EXCL PCGE,
105: IGS_PE_PERSENC_EFFCT PEE
106: WHERE PCGE.person_id = cp_person_id AND
107: PCGE.encumbrance_type = cp_encumbrance_type AND
108: PCGE.pen_start_dt = cp_start_dt AND

Line 246: -- SELECTING ALL IGS_PE_CRS_GRP_EXCL RECORDS

242:
243:
244:
245: END IF;
246: -- SELECTING ALL IGS_PE_CRS_GRP_EXCL RECORDS
247: FOR v_psn_crs_grp_excl_rec IN c_psn_crs_grp_excl(p_person_id,
248: p_encumbrance_type,
249: p_start_dt,
250: p_expiry_dt) LOOP

Line 251: -- for each IGS_PE_CRS_GRP_EXCL record returned,

247: FOR v_psn_crs_grp_excl_rec IN c_psn_crs_grp_excl(p_person_id,
248: p_encumbrance_type,
249: p_start_dt,
250: p_expiry_dt) LOOP
251: -- for each IGS_PE_CRS_GRP_EXCL record returned,
252: -- update the expiry_dt
253: IF (v_psn_crs_grp_excl_rec.pcge_start_dt > p_expiry_dt) THEN
254:
255: Igs_Pe_Crs_Grp_Excl_Pkg.UPDATE_ROW(

Line 255: Igs_Pe_Crs_Grp_Excl_Pkg.UPDATE_ROW(

251: -- for each IGS_PE_CRS_GRP_EXCL record returned,
252: -- update the expiry_dt
253: IF (v_psn_crs_grp_excl_rec.pcge_start_dt > p_expiry_dt) THEN
254:
255: Igs_Pe_Crs_Grp_Excl_Pkg.UPDATE_ROW(
256: X_ROWID => v_psn_crs_grp_excl_rec.ROWID ,
257: X_PERSON_ID => v_psn_crs_grp_excl_rec.PERSON_ID ,
258: X_ENCUMBRANCE_TYPE => v_psn_crs_grp_excl_rec.ENCUMBRANCE_TYPE ,
259: X_PEN_START_DT => v_psn_crs_grp_excl_rec.PEN_START_DT ,

Line 271: Igs_Pe_Crs_Grp_Excl_Pkg.UPDATE_ROW(

267: );
268:
269:
270: ELSE
271: Igs_Pe_Crs_Grp_Excl_Pkg.UPDATE_ROW(
272: X_ROWID => v_psn_crs_grp_excl_rec.ROWID ,
273: X_PERSON_ID => v_psn_crs_grp_excl_rec.PERSON_ID ,
274: X_ENCUMBRANCE_TYPE => v_psn_crs_grp_excl_rec.ENCUMBRANCE_TYPE ,
275: X_PEN_START_DT => v_psn_crs_grp_excl_rec.PEN_START_DT ,