APPS.IGS_EN_GEN_011 dependencies on IGS_PE_PERS_UNT_EXCL

Line 5498: SELECT rowid,IGS_PE_PERS_UNT_EXCL.*

5494: (expiry_dt IS NULL OR
5495: expiry_dt > p_expiry_dt)
5496: FOR UPDATE OF expiry_dt NOWAIT;
5497: CURSOR c_person_unit_exclusion IS
5498: SELECT rowid,IGS_PE_PERS_UNT_EXCL.*
5499: FROM IGS_PE_PERS_UNT_EXCL
5500: WHERE
5501: person_id = p_person_id AND
5502: encumbrance_type = p_encumbrance_type AND

Line 5499: FROM IGS_PE_PERS_UNT_EXCL

5495: expiry_dt > p_expiry_dt)
5496: FOR UPDATE OF expiry_dt NOWAIT;
5497: CURSOR c_person_unit_exclusion IS
5498: SELECT rowid,IGS_PE_PERS_UNT_EXCL.*
5499: FROM IGS_PE_PERS_UNT_EXCL
5500: WHERE
5501: person_id = p_person_id AND
5502: encumbrance_type = p_encumbrance_type AND
5503: pen_start_dt = p_pen_start_dt AND

Line 5605: IGS_PE_PERS_UNT_EXCL_PKG.UPDATE_ROW(

5601: p_expiry_dt)
5602: INTO l_dcd_date
5603: FROM DUAL;
5604:
5605: IGS_PE_PERS_UNT_EXCL_PKG.UPDATE_ROW(
5606: X_ROWID => v_pue_rec.ROWID ,
5607: X_PERSON_ID => v_pue_rec.PERSON_ID ,
5608: X_ENCUMBRANCE_TYPE => v_pue_rec.ENCUMBRANCE_TYPE ,
5609: X_PEN_START_DT => v_pue_rec.PEN_START_DT ,