APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_PE_TYP_INSTANCES

Line 144: FROM igs_pe_typ_instances typeinst

140: l_decision_reason_id_found VARCHAR2(1);
141: l_pending_reason_id_found VARCHAR2(1);
142: CURSOR c_decision_maker (cp_decision_maker_id igs_pe_person_base_v.person_id%TYPE) IS
143: SELECT 'x'
144: FROM igs_pe_typ_instances typeinst
145: WHERE typeinst.person_id = cp_decision_maker_id
146: AND typeinst.system_type IN ('STAFF','FACULTY')
147: AND (SYSDATE between typeinst.start_date AND NVL(typeinst.end_date,SYSDATE));
148: