APPS.IGS_AS_SS_DOC_REQUEST dependencies on IGS_PE_PERSENC_EFFCT

Line 105: FROM igs_pe_persenc_effct

101: --
102: CURSOR c_hold IS
103: SELECT encumbrance_type,
104: pee_start_dt
105: FROM igs_pe_persenc_effct
106: WHERE person_id = p_person_id
107: AND s_encmb_effect_type IN ('TRANS_BLK','RVK_SRVC','SUS_SRVC','RESULT_BLK')
108: AND NVL (expiry_dt, SYSDATE) >= SYSDATE
109: AND pee_start_dt < SYSDATE