DBA Data[Home] [Help]

APPS.CSD_REPAIRS_UTIL dependencies on CSI_IP_ACCOUNTS

Line 1285: from csi_ip_accounts

1281: -- Cursor to derive the Instance Account Id
1282: Cursor c_instance_account(p_instance_party_id number) is
1283: Select ip_account_id,
1284: object_version_number
1285: from csi_ip_accounts
1286: where instance_party_id = p_instance_party_id;
1287:
1288: -- Cursor to derive party information from hz_parties
1289: Cursor c_hz_parties_info(p_party_id number) is

Line 1313: FROM CSI_IP_ACCOUNTS

1309:
1310: --bug#8508030
1311: Cursor get_bill_to_ship_to_address(p_instance_id number) IS
1312: SELECT bill_to_address,ship_to_address
1313: FROM CSI_IP_ACCOUNTS
1314: WHERE INSTANCE_PARTY_ID =
1315: (SELECT instance_party_id FROM CSI_I_PARTIES
1316: WHERE INSTANCE_ID=p_instance_id
1317: AND relationship_type_code='OWNER');