APPS.IGS_FI_GEN_REFUNDS dependencies on IGS_PE_PERSENC_EFFCT

Line 158: FROM igs_pe_persenc_effct

154:
155: CURSOR cur_hold_check (cp_person_id igs_pe_person.person_id%TYPE)
156: IS
157: SELECT 'X'
158: FROM igs_pe_persenc_effct
159: WHERE person_id = cp_person_id
160: AND s_encmb_effect_type = g_stoprefund
161: AND TRUNC(NVL(expiry_dt,SYSDATE)) >= TRUNC(SYSDATE);
162: