DBA Data[Home] [Help]

APPS.CSD_BULK_RECEIVE_UTIL dependencies on CSI_IP_ACCOUNTS

Line 1574: from csi_ip_accounts

1570: -- Cursor to derive the Instance Account Id
1571: Cursor c_instance_account(p_instance_party_id number) is
1572: Select ip_account_id,
1573: object_version_number
1574: from csi_ip_accounts
1575: where instance_party_id = p_instance_party_id;
1576:
1577: -- Cursor to get IB details
1578: Cursor c_get_ib_info ( p_inventory_item_id in Number,p_serial_number in Varchar2) is

Line 1587: FROM CSI_IP_ACCOUNTS

1583:
1584: --bug#8508030
1585: Cursor get_bill_to_ship_to_address(p_instance_id number) IS
1586: SELECT bill_to_address,ship_to_address
1587: FROM CSI_IP_ACCOUNTS
1588: WHERE INSTANCE_PARTY_ID =
1589: (SELECT instance_party_id FROM CSI_I_PARTIES
1590: WHERE INSTANCE_ID=p_instance_id
1591: AND relationship_type_code='OWNER');