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_GE_GEN_003 dependencies on IGS_PE_PERSON_BASE_V

Line 596: FROM igs_pe_person_base_v

592: -- This cursor will fetch no records when the person is not exists in the system
593: -- or more than one person is matching the criteria.
594: CURSOR cur_person_id IS
595: SELECT person_id
596: FROM igs_pe_person_base_v
597: WHERE person_number = p_person_number
598: AND 1 = (SELECT COUNT(*)
599: FROM igs_pe_person_base_v
600: WHERE person_number = p_person_number);

Line 599: FROM igs_pe_person_base_v

595: SELECT person_id
596: FROM igs_pe_person_base_v
597: WHERE person_number = p_person_number
598: AND 1 = (SELECT COUNT(*)
599: FROM igs_pe_person_base_v
600: WHERE person_number = p_person_number);
601:
602: l_person_id igs_pe_person_base_v.person_id%TYPE;
603: BEGIN

Line 602: l_person_id igs_pe_person_base_v.person_id%TYPE;

598: AND 1 = (SELECT COUNT(*)
599: FROM igs_pe_person_base_v
600: WHERE person_number = p_person_number);
601:
602: l_person_id igs_pe_person_base_v.person_id%TYPE;
603: BEGIN
604:
605: l_person_id := NULL;
606: