APPS.IGS_EN_GEN_011 dependencies on IGS_PE_CRS_GRP_EXCL

Line 5471: SELECT rowid, IGS_PE_CRS_GRP_EXCL.*

5467: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
5468: v_check VARCHAR2(1);
5469: v_ret_val BOOLEAN := TRUE;
5470: CURSOR c_person_crs_grp_exclusion IS
5471: SELECT rowid, IGS_PE_CRS_GRP_EXCL.*
5472: FROM IGS_PE_CRS_GRP_EXCL
5473: WHERE
5474: person_id = p_person_id AND
5475: encumbrance_type = p_encumbrance_type AND

Line 5472: FROM IGS_PE_CRS_GRP_EXCL

5468: v_check VARCHAR2(1);
5469: v_ret_val BOOLEAN := TRUE;
5470: CURSOR c_person_crs_grp_exclusion IS
5471: SELECT rowid, IGS_PE_CRS_GRP_EXCL.*
5472: FROM IGS_PE_CRS_GRP_EXCL
5473: WHERE
5474: person_id = p_person_id AND
5475: encumbrance_type = p_encumbrance_type AND
5476: pen_start_dt = p_pen_start_dt AND

Line 5560: IGS_PE_CRS_GRP_EXCL_PKG.UPDATE_ROW(

5556: SELECT DECODE(GREATEST(v_pcge_rec.pcge_start_dt, p_expiry_dt),v_pcge_rec.pcge_start_dt, v_pcge_rec.pcge_start_dt, p_expiry_dt)
5557: INTO l_dcd_date
5558: FROM DUAL;
5559:
5560: IGS_PE_CRS_GRP_EXCL_PKG.UPDATE_ROW(
5561: X_ROWID => v_pcge_rec.ROWID ,
5562: X_PERSON_ID => v_pcge_rec.PERSON_ID ,
5563: X_ENCUMBRANCE_TYPE => v_pcge_rec.ENCUMBRANCE_TYPE ,
5564: X_PEN_START_DT => v_pcge_rec.PEN_START_DT ,