APPS.IGS_HE_IMPORT_POPDLHE dependencies on HZ_PARTIES

Line 560: FROM hz_parties

556: *******************************************************************/
557: -- Determines PersonID from ownstu (party number)
558: CURSOR c_ownstu (cp_ownstu igs_he_popdlhe_ints.ownstu%TYPE) IS
559: SELECT party_id
560: FROM hz_parties
561: WHERE party_number = cp_ownstu;
562:
563: -- Determines PersonID from alternateID table using HUSID
564: CURSOR c_husid (cp_husid igs_he_popdlhe_ints.husid%TYPE) IS

Line 576: -- try using owntsu to lookup hz_parties first

572: l_person_id NUMBER;
573:
574: BEGIN
575:
576: -- try using owntsu to lookup hz_parties first
577: IF p_popdlhe_dtls.ownstu IS NOT NULL THEN
578:
579: OPEN c_ownstu(p_popdlhe_dtls.ownstu);
580: FETCH c_ownstu INTO l_person_id;