992: from hz_party_site_uses
993: where party_site_use_id = p_install_site_id;
994: Cursor c_instance_number(p_instance_id Number) is
995: select instance_number
996: from csi_item_instances
997: where instance_id = p_instance_id;
998:
999: Cursor c_internal_party_id Is
1000: select internal_party_id
1789: from hz_party_site_uses
1790: where party_site_use_id = p_install_site_id;
1791: Cursor c_instance_number(p_instance_id Number) is
1792: select instance_number
1793: from csi_item_instances
1794: where instance_id = p_instance_id;
1795:
1796:
1797: