DBA Data[Home] [Help]

APPS.IGS_PE_HEARING_DTLS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 98: IGS_PE_PERSON_BASE_V

94: --Who When What
95: ----------------------------------------------------------------------------------------------
96: CURSOR validate_cr_dt IS
97: SELECT birth_date FROM
98: IGS_PE_PERSON_BASE_V
99: WHERE person_id = new_references.person_id ;
100:
101: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
102:

Line 101: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;

97: SELECT birth_date FROM
98: IGS_PE_PERSON_BASE_V
99: WHERE person_id = new_references.person_id ;
100:
101: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
102:
103: BEGIN
104: IF p_inserting OR p_updating THEN
105: OPEN validate_cr_dt;