63: status = 'A';
64:
65: Cursor get_address is
66: SELECT b.address1
67: FROM hz_party_sites a, hz_locations b
68: WHERE a.location_id = b.location_id
69: AND a.party_site_id = p_party_site_id;
70:
71: Cursor get_inv_org_name is
85: x_account_id := FND_API.G_MISS_NUM;
86: ELSE
87: SELECT party_id
88: INTO l_party_id
89: FROM HZ_PARTY_SITES
90: WHERE party_site_id = p_party_site_id;
91:
92: IF l_party_id = p_sold_to_customer_party THEN
93: IF p_sold_to_customer_account is not null then
214: status = p_status;
215:
216: Cursor get_address is
217: SELECT b.address1
218: FROM hz_party_sites a, hz_locations b
219: WHERE a.location_id = b.location_id
220: AND a.party_site_id = p_party_site_id;
221:
222: Cursor get_inv_org_name is