APPS.OZF_TRADE_PROFILE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 456: from HZ_CUST_ACCOUNTS

452: WHERE TRADE_PROFILE_ID = l_id;
453:
454: CURSOR c_customer_id (p_id IN NUMBER) IS
455: SELECT cust_account_id
456: from HZ_CUST_ACCOUNTS
457: WHERE party_id = p_id
458: AND status = 'A';
459:
460: CURSOR c_party_id (c_id IN NUMBER) IS

Line 462: from HZ_CUST_ACCOUNTS

458: AND status = 'A';
459:
460: CURSOR c_party_id (c_id IN NUMBER) IS
461: SELECT party_id
462: from HZ_CUST_ACCOUNTS
463: WHERE cust_account_id = c_id;
464:
465: BEGIN
466:

Line 1343: from HZ_CUST_ACCOUNTS

1339: l_trade_profile_rec trade_profile_rec_type;
1340:
1341: CURSOR c_party_id (c_id IN NUMBER) IS
1342: SELECT party_id
1343: from HZ_CUST_ACCOUNTS
1344: WHERE cust_account_id = c_id;
1345:
1346: BEGIN
1347: x_return_status := FND_API.g_ret_sts_success;