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

Line 284: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

280: v_number_of_matches NUMBER(4);
281: CURSOR c_pe (
282: cp_previous_family_name IGS_PE_PERSON.surname%TYPE) IS
283: SELECT pe.person_id
284: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
285: WHERE pe.last_name = cp_previous_family_name AND
286: pe.birth_date = p_convert_birth_dt;
287: BEGIN -- admpl_match_criteria11
288: -- Find match on previous family name and date of birth

Line 317: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

313: cst_match10 CONSTANT VARCHAR2(3) := 'CFB';
314: v_number_of_matches NUMBER(4);
315: CURSOR c_pe IS
316: SELECT pe.person_id
317: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
318: WHERE pe.last_name = p_convert_family_name AND
319: pe.birth_date = p_convert_birth_dt;
320: BEGIN -- admpl_match_criteria10
321: -- Find match on current family name and date of birth

Line 453: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

449: v_other_names IGS_PE_PERSON.given_names%TYPE;
450: CURSOR c_pe (
451: cp_previous_family_name IGS_PE_PERSON.surname%TYPE) IS
452: SELECT pe.person_id
453: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
454: WHERE pe.last_name = cp_previous_family_name AND
455: pe.birth_date = p_convert_birth_dt;
456: BEGIN -- admpl_match_criteria7
457: -- Find match on previous family name, a given name and date of birth

Line 514: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

510: v_db_given_name IGS_PE_PERSON.given_names%TYPE;
511: v_other_names IGS_PE_PERSON.given_names%TYPE;
512: CURSOR c_pe IS
513: SELECT pe.person_id
514: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
515: WHERE pe.last_name = p_convert_family_name AND
516: pe.birth_date = p_convert_birth_dt;
517: BEGIN -- admpl_match_criteria6
518: -- Find match on current family name, a given name and date of birth

Line 590: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

586: v_number_of_matches NUMBER(4);
587: v_person_id IGS_PE_PERSON.person_id%TYPE;
588: CURSOR c_pe IS
589: SELECT pe.person_id
590: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
591: WHERE pe.person_id = p_convert_id AND
592: pe.birth_date = p_convert_birth_dt;
593: BEGIN -- admpl_match_criteria4a
594: -- Find match on person ID and date of birth

Line 750: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

746: v_other_names IGS_PE_PERSON.given_names%TYPE;
747: CURSOR c_pe (
748: cp_previous_family_name IGS_PE_PERSON.surname%TYPE) IS
749: SELECT pe.person_id
750: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
751: WHERE pe.person_id = p_convert_id AND
752: pe.last_name = cp_previous_family_name AND
753: pe.birth_date = p_convert_birth_dt;
754: BEGIN -- admpl_match_criteria2

Line 821: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

817: v_db_given_name IGS_PE_PERSON.given_names%TYPE;
818: v_other_names IGS_PE_PERSON.given_names%TYPE;
819: CURSOR c_pe IS
820: SELECT pe.person_id
821: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
822: WHERE pe.person_id = p_convert_id AND
823: pe.last_name = p_convert_family_name AND
824: pe.birth_date = p_convert_birth_dt;
825: BEGIN -- admpl_match_criteria1

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

1355: SELECT pe.person_id person_id,
1356: pe.last_name surname,
1357: pe.first_name given_names,
1358: pe.birth_date birth_dt
1359: FROM igs_pe_person_base_v pe /* Replaced IGS_PE_PERSON with igs_pe_person_base_v Bug 3150054 */
1360: WHERE pe.person_id = p_matched_id;
1361: CURSOR c_sua_sca IS
1362: SELECT sca.course_rqrmnt_complete_ind,
1363: sca.person_id,