64:
65: END HZ_Postcode_City_fk;
66:
67: /* This API returns the PK in Party Site for this customer site use id
68: by joining to HZ_CUST_ACCT_SITES_ALL to get party_site_id */
69:
70: Function Customer_Site_Location_fk
71: (p_site_use_id in NUMBER,
72: p_instance_code in VARCHAR2 :=NULL) return VARCHAR2 IS
92:
93: END IF;
94:
95: select party_site_id into l_party_site_id
96: from HZ_CUST_ACCT_SITES_ALL hcas,
97: HZ_CUST_SITE_USES_ALL hcsu
98: where hcsu.site_use_id = p_site_use_id
99: and hcsu.cust_acct_site_id = hcas.cust_acct_site_id;
100: