19: TYPE party_rec_type IS RECORD (
20: party_id HZ_PARTIES.PARTY_ID%TYPE
21: ,party_name HZ_PARTIES.PARTY_NAME%TYPE
22: ,party_type HZ_PARTIES.PARTY_TYPE%TYPE
23: ,date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE
24: ,place_of_birth HZ_PERSON_PROFILES.PLACE_OF_BIRTH%TYPE
25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
20: party_id HZ_PARTIES.PARTY_ID%TYPE
21: ,party_name HZ_PARTIES.PARTY_NAME%TYPE
22: ,party_type HZ_PARTIES.PARTY_TYPE%TYPE
23: ,date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE
24: ,place_of_birth HZ_PERSON_PROFILES.PLACE_OF_BIRTH%TYPE
25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
21: ,party_name HZ_PARTIES.PARTY_NAME%TYPE
22: ,party_type HZ_PARTIES.PARTY_TYPE%TYPE
23: ,date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE
24: ,place_of_birth HZ_PERSON_PROFILES.PLACE_OF_BIRTH%TYPE
25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
22: ,party_type HZ_PARTIES.PARTY_TYPE%TYPE
23: ,date_of_birth HZ_PERSON_PROFILES.DATE_OF_BIRTH%TYPE
24: ,place_of_birth HZ_PERSON_PROFILES.PLACE_OF_BIRTH%TYPE
25: ,person_identifier HZ_PERSON_PROFILES.PERSON_IDENTIFIER%TYPE
26: ,person_iden_type HZ_PERSON_PROFILES.PERSON_IDEN_TYPE%TYPE
27: ,country HZ_LOCATIONS.COUNTRY%TYPE
28: ,address1 HZ_LOCATIONS.ADDRESS3%TYPE
29: ,address2 HZ_LOCATIONS.ADDRESS2%TYPE
30: ,address3 HZ_LOCATIONS.ADDRESS1%TYPE