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 HZ_PARTIES

Line 350: FROM hz_parties hz

346: v_other_names IGS_PE_PERSON.given_names%TYPE;
347: CURSOR c_pe (
348: cp_previous_family_name IGS_PE_PERSON.surname%TYPE) IS
349: SELECT hz.party_id person_id /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
350: FROM hz_parties hz
351: WHERE hz.person_last_name = cp_previous_family_name;
352: BEGIN -- admpl_match_criteria9
353: -- Find match on previous family name and a given name
354: FOR i IN 1..v_previous_name_records_cnt LOOP

Line 410: FROM hz_parties hz

406: v_db_given_name IGS_PE_PERSON.given_names%TYPE;
407: v_other_names IGS_PE_PERSON.given_names%TYPE;
408: CURSOR c_pe IS
409: SELECT hz.party_id person_id
410: FROM hz_parties hz
411: WHERE hz.person_last_name = p_convert_family_name;
412: BEGIN -- p_convert_family_name
413: -- Find match on current family name and a given name
414: FOR v_pe_rec IN c_pe LOOP

Line 555: FROM hz_parties hz

551: v_number_of_matches NUMBER(4);
552: v_person_id IGS_PE_PERSON.person_id%TYPE;
553: CURSOR c_pe IS
554: SELECT hz.party_id person_id /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
555: FROM hz_parties hz
556: WHERE hz.party_id = p_convert_id;
557: BEGIN -- admpl_match_criteria5
558: -- Find match on person ID only
559: OPEN c_pe;

Line 630: FROM hz_parties hz /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

626: v_other_names IGS_PE_PERSON.given_names%TYPE;
627: CURSOR c_pe (
628: cp_previous_family_name IGS_PE_PERSON.surname%TYPE) IS
629: SELECT hz.party_id person_id
630: FROM hz_parties hz /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
631: WHERE hz.party_id = p_convert_id AND
632: hz.person_last_name = cp_previous_family_name;
633: BEGIN -- admpl_match_criteria4
634: -- Find match on person_id, previous family name and a given name

Line 698: FROM hz_parties hz /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */

694: v_db_given_name IGS_PE_PERSON.given_names%TYPE;
695: v_other_names IGS_PE_PERSON.given_names%TYPE;
696: CURSOR c_pe IS
697: SELECT hz.party_id person_id
698: FROM hz_parties hz /* Replaced IGS_PE_PERSON with HZ tables Bug 3150054 */
699: WHERE hz.party_id = p_convert_id AND
700: hz.person_last_name = p_convert_family_name;
701: BEGIN -- admpl_match_criteria3
702: -- Find match on person ID, current family name and a given name