DBA Data[Home] [Help]

APPS.IGS_PE_IMMU_DTLS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 137: IGS_PE_PERSON_BASE_V

133: --Who When What
134: ----------------------------------------------------------------------------------------------
135: CURSOR validate_brth_dt(cp_person_id NUMBER) IS
136: SELECT birth_date FROM
137: IGS_PE_PERSON_BASE_V
138: WHERE person_id = cp_person_id ;
139:
140: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
141:

Line 140: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

136: SELECT birth_date FROM
137: IGS_PE_PERSON_BASE_V
138: WHERE person_id = cp_person_id ;
139:
140: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;
141:
142: BEGIN
143: IF p_inserting OR p_updating THEN
144: OPEN validate_brth_dt(new_references.person_id);