DBA Data[Home] [Help]

APPS.IGS_PE_FELONY_DTLS_PKG dependencies on IGS_PE_PERSON_BASE_V

Line 95: IGS_PE_PERSON_BASE_V

91: --gmaheswa 12-Aug-2005 4327807: Added the validation Crime date shouldn't be greater than sysdate.
92: ----------------------------------------------------------------------------------------------
93: CURSOR validate_cr_dt IS
94: SELECT birth_date FROM
95: IGS_PE_PERSON_BASE_V
96: WHERE person_id = new_references.person_id ;
97:
98: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
99:

Line 98: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;

94: SELECT birth_date FROM
95: IGS_PE_PERSON_BASE_V
96: WHERE person_id = new_references.person_id ;
97:
98: l_birth_dt IGS_PE_PERSON_BASE_V.BIRTH_DATE%TYPE;
99:
100: Cursor mes_token IS
101: SELECT meaning FROM
102: IGS_LOOKUP_VALUES WHERE