APPS.IGS_EN_GEN_003 dependencies on IGS_PE_PERS_ENCUMB

Line 144: FROM IGS_PE_PERS_ENCUMB

140:
141: CURSOR c_prsn_encumb
142: (cp_person_id IGS_PE_PERSON.person_id%TYPE) IS
143: SELECT 1
144: FROM IGS_PE_PERS_ENCUMB
145: WHERE person_id = cp_person_id AND
146: (l_sysdate BETWEEN start_dt AND (expiry_dt - 1) OR
147: (expiry_dt IS NULL AND start_dt <= l_sysdate)) ;
148: