450: WHERE TRADE_PROFILE_ID = l_id;
451:
452: CURSOR c_customer_id (p_id IN NUMBER) IS
453: SELECT cust_account_id
454: from HZ_CUST_ACCOUNTS
455: WHERE party_id = p_id
456: AND status = 'A';
457:
458: CURSOR c_party_id (c_id IN NUMBER) IS
456: AND status = 'A';
457:
458: CURSOR c_party_id (c_id IN NUMBER) IS
459: SELECT party_id
460: from HZ_CUST_ACCOUNTS
461: WHERE cust_account_id = c_id;
462:
463: BEGIN
464:
1337: l_trade_profile_rec trade_profile_rec_type;
1338:
1339: CURSOR c_party_id (c_id IN NUMBER) IS
1340: SELECT party_id
1341: from HZ_CUST_ACCOUNTS
1342: WHERE cust_account_id = c_id;
1343:
1344: BEGIN
1345: x_return_status := FND_API.g_ret_sts_success;