eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_VAL_PE dependencies on IGS_PE_PERSON

Line 14: v_person_id IGS_PE_PERSON.person_id%TYPE;

10: p_message_name OUT NOCOPY VARCHAR2 )
11: RETURN boolean AS
12: BEGIN
13: DECLARE
14: v_person_id IGS_PE_PERSON.person_id%TYPE;
15: CURSOR c_pe IS
16: SELECT pe.person_id
17: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with igs_pe_person_base_v Bug 3150054 */
18: WHERE pe.person_id = p_person_id AND

Line 17: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with igs_pe_person_base_v Bug 3150054 */

13: DECLARE
14: v_person_id IGS_PE_PERSON.person_id%TYPE;
15: CURSOR c_pe IS
16: SELECT pe.person_id
17: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with igs_pe_person_base_v Bug 3150054 */
18: WHERE pe.person_id = p_person_id AND
19: pe.last_name = p_surname AND
20: pe.birth_date = p_birth_dt;
21: