DBA Data[Home] [Help]

APPS.FUN_NET_ARAP_PKG dependencies on HZ_CUST_ACCT_SITES_ALL

Line 3048: hz_cust_acct_sites_all s,

3044: CURSOR c_get_site_use_id(p_cust_acct_id NUMBER) IS
3045: SELECT u.site_use_id
3046: INTO p_cust_site_use_id
3047: FROM fun_net_customers_all fc,
3048: hz_cust_acct_sites_all s,
3049: hz_cust_site_uses_all u
3050: WHERE fc.agreement_id = g_agreement_id
3051: AND fc.cust_account_id = p_cust_acct_id
3052: AND fc.cust_account_id = s.cust_account_id