APPS.IGS_AD_IMP_ADM_DES dependencies on IGS_PE_PERSON_BASE_V

Line 142: CURSOR c_decision_maker (cp_decision_maker_id igs_pe_person_base_v.person_id%TYPE) IS

138: AND closed_ind = 'N';
139:
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')

Line 151: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd

147: AND (SYSDATE between typeinst.start_date AND NVL(typeinst.end_date,SYSDATE));
148:
149: CURSOR c_dmi (cp_person_id NUMBER) IS
150: SELECT 'X'
151: FROM igs_pe_person_base_v base, igs_pe_hz_parties pd
152: WHERE base.person_id = cp_person_id
153: AND base.person_id = pd.party_id (+)
154: AND DECODE(base.date_of_death,NULL,NVL(pd.deceased_ind,'N'),'Y') = 'Y';
155: