APPS.OZF_SUPP_TRADE_PROFILE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 865: from HZ_CUST_ACCOUNTS

861: WHERE SUPP_TRADE_PROFILE_ID = l_id;
862:
863: CURSOR c_customer_id (p_id IN NUMBER) IS
864: SELECT cust_account_id
865: from HZ_CUST_ACCOUNTS
866: WHERE party_id = p_id
867: AND status = 'A';
868:
869: CURSOR c_party_id (c_id IN NUMBER) IS

Line 871: from HZ_CUST_ACCOUNTS

867: AND status = 'A';
868:
869: CURSOR c_party_id (c_id IN NUMBER) IS
870: SELECT party_id
871: from HZ_CUST_ACCOUNTS
872: WHERE cust_account_id = c_id;
873:
874: BEGIN
875:

Line 1795: from HZ_CUST_ACCOUNTS

1791: l_supp_trade_profile_rec supp_trade_profile_rec_type;
1792:
1793: CURSOR c_party_id (c_id IN NUMBER) IS
1794: SELECT party_id
1795: from HZ_CUST_ACCOUNTS
1796: WHERE cust_account_id = c_id;
1797:
1798: BEGIN
1799: x_return_status := FND_API.g_ret_sts_success;