APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on HZ_LOCATIONS
Line 67: FROM hz_party_sites a, hz_locations b
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
Line 218: FROM hz_party_sites a, hz_locations b
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