APPS.IGS_PE_HLTH_INS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 145: IGS_PE_PERSON_BASE_V

141: --Who When What
142: ----------------------------------------------------------------------------------------------
143: CURSOR validate_brth_dt(cp_person_id NUMBER) IS
144: SELECT birth_date FROM
145: IGS_PE_PERSON_BASE_V
146: WHERE person_id = cp_person_id ;
147:
148: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
149:

Line 148: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

144: SELECT birth_date FROM
145: IGS_PE_PERSON_BASE_V
146: WHERE person_id = cp_person_id ;
147:
148: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
149:
150: BEGIN
151: IF p_inserting OR p_updating THEN
152: OPEN validate_brth_dt(new_references.person_id);