DBA Data[Home] [Help]

APPS.IGS_PE_MIL_SERVICES_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 147: FROM IGS_PE_PERSON_BASE_V

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

Line 150: l_bth_dt IGS_PE_PERSON_BASE_V.birth_date%TYPE;

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