APPS.OZF_SUPP_TRADE_PROFILE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 758: from HZ_CUST_ACCOUNTS

754: WHERE SUPP_TRADE_PROFILE_ID = l_id;
755:
756: CURSOR c_customer_id (p_id IN NUMBER) IS
757: SELECT cust_account_id
758: from HZ_CUST_ACCOUNTS
759: WHERE party_id = p_id
760: AND status = 'A';
761:
762: CURSOR c_party_id (c_id IN NUMBER) IS

Line 764: from HZ_CUST_ACCOUNTS

760: AND status = 'A';
761:
762: CURSOR c_party_id (c_id IN NUMBER) IS
763: SELECT party_id
764: from HZ_CUST_ACCOUNTS
765: WHERE cust_account_id = c_id;
766:
767: BEGIN
768:

Line 1664: from HZ_CUST_ACCOUNTS

1660: l_supp_trade_profile_rec supp_trade_profile_rec_type;
1661:
1662: CURSOR c_party_id (c_id IN NUMBER) IS
1663: SELECT party_id
1664: from HZ_CUST_ACCOUNTS
1665: WHERE cust_account_id = c_id;
1666:
1667: BEGIN
1668: x_return_status := FND_API.g_ret_sts_success;