APPS.IGS_PE_EIT_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 274: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

270: --Change History:
271: --Who When What
272: ----------------------------------------------------------------------------------------------
273:
274: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
275: l_default_date DATE := TO_DATE('4712/12/31','YYYY/MM/DD');
276: v_st_res VARCHAR2(60) ;
277:
278: CURSOR validate_brth_dt(cp_person_id NUMBER) IS

Line 280: FROM IGS_PE_PERSON_BASE_V

276: v_st_res VARCHAR2(60) ;
277:
278: CURSOR validate_brth_dt(cp_person_id NUMBER) IS
279: SELECT birth_date
280: FROM IGS_PE_PERSON_BASE_V
281: WHERE person_id = cp_person_id ;
282:
283: CURSOR validate_dt_overlap(cp_person_id NUMBER, cp_pe_eit_id NUMBER, cp_information_type VARCHAR2,
284: cp_start_date DATE, cp_end_date DATE) IS