APPS.IGS_EN_GEN_011 dependencies on IGS_PE_UNT_REQUIRMNT

Line 5526: SELECT rowid,IGS_PE_UNT_REQUIRMNT.*

5522: expiry_dt > p_expiry_dt)
5523: FOR UPDATE OF expiry_dt NOWAIT;
5524:
5525: CURSOR c_person_unit_requirement IS
5526: SELECT rowid,IGS_PE_UNT_REQUIRMNT.*
5527: FROM IGS_PE_UNT_REQUIRMNT
5528: WHERE
5529: person_id = p_person_id AND
5530: encumbrance_type = p_encumbrance_type AND

Line 5527: FROM IGS_PE_UNT_REQUIRMNT

5523: FOR UPDATE OF expiry_dt NOWAIT;
5524:
5525: CURSOR c_person_unit_requirement IS
5526: SELECT rowid,IGS_PE_UNT_REQUIRMNT.*
5527: FROM IGS_PE_UNT_REQUIRMNT
5528: WHERE
5529: person_id = p_person_id AND
5530: encumbrance_type = p_encumbrance_type AND
5531: pen_start_dt = p_pen_start_dt AND

Line 5627: IGS_PE_UNT_REQUIRMNT_PKG.UPDATE_ROW(

5623: INTO l_dcd_date
5624: FROM DUAL;
5625:
5626:
5627: IGS_PE_UNT_REQUIRMNT_PKG.UPDATE_ROW(
5628: X_ROWID => v_pur_rec.ROWID ,
5629: X_PERSON_ID => v_pur_rec.PERSON_ID ,
5630: X_ENCUMBRANCE_TYPE => v_pur_rec.ENCUMBRANCE_TYPE ,
5631: X_PEN_START_DT => v_pur_rec.PEN_START_DT ,