APPS.IGS_PE_PERSON_ADDR_PKG dependencies on HZ_PARTY_SITE_NUMBER_S

Line 57: SELECT hz_party_site_number_s.NEXTVAL

53: WHERE party_id = p_party_id AND effective_end_Date IS NULL;
54: l_date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE;
55:
56: CURSOR c_party_site_number IS
57: SELECT hz_party_site_number_s.NEXTVAL
58: FROM dual;
59:
60: l_party_site_number HZ_PARTY_SITES.PARTY_SITE_NUMBER%TYPE;
61: l_hz_gen_party_site VARCHAR2(10);