DBA Data[Home] [Help]

APPS.CSI_UTL_PKG dependencies on CSI_IP_ACCOUNTS

Line 246: FROM csi_ip_accounts

242: SELECT object_version_number,
243: ip_account_id
244: INTO x_obj_version_number,
245: x_ip_account_id
246: FROM csi_ip_accounts
247: WHERE instance_party_id = p_instance_pty_id
248: AND relationship_type_code = p_rel_type_code
249: AND ((active_end_date is null ) OR
250: (active_end_date > sysdate));

Line 398: FROM csi_ip_accounts

394: api_log('get_acct_obj_ver_num');
395:
396: SELECT object_version_number
397: INTO l_obj_ver_num
398: FROM csi_ip_accounts
399: WHERE ip_account_id = p_ip_acct_id
400: AND ((active_end_date is null ) OR
401: (active_end_date > sysdate));
402: RETURN l_obj_ver_num;

Line 1434: FROM csi_ip_accounts

1430:
1431: SELECT
1432: ip_account_id
1433: INTO l_ip_acct_id
1434: FROM csi_ip_accounts
1435: WHERE instance_party_id = p_instance_party_id
1436: AND relationship_type_code = 'OWNER'
1437: AND ((active_end_date is null)
1438: OR (active_end_date >= sysdate));

Line 2541: FROM csi_ip_accounts

2537: SELECT ip_account_id,
2538: object_version_number
2539: INTO x_i_pa_rec.ip_account_id,
2540: x_i_pa_rec.object_version_number
2541: FROM csi_ip_accounts
2542: WHERE instance_party_id = p_instance_party_id
2543: AND party_account_id = x_i_pa_rec.party_account_id
2544: AND relationship_type_code = x_i_pa_rec.relationship_type_code;
2545: EXCEPTION