APPS.FUN_NET_ARAP_PKG dependencies on FUN_NET_CUSTOMERS

Line 325: fun_net_customers_all fnc ';

321: l_trx_from_clause :=
322: ' FROM ra_customer_trx_all rct,
323: ar_payment_schedules_all arps,
324: ra_cust_trx_types_all rctt,
325: fun_net_customers_all fnc ';
326: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);
327:
328: -- Build the WHERE clause --
329: /* Only select the transactions where the due date is on or before the Tnx due date in the batch */

Line 2368: FROM fun_net_customers ca

2364:
2365:
2366: SELECT min(cust_account_id)
2367: INTO p_cust_acct_id
2368: FROM fun_net_customers ca
2369: WHERE ca.agreement_id = g_agreement_id
2370: AND cust_priority = 1;
2371:
2372:

Line 2377: fun_net_customers fc,

2373: -- Bug 6982905. added AND u.org_id = fc.org_id to the query
2374: SELECT u.site_use_id
2375: INTO p_cust_site_use_id
2376: FROM
2377: fun_net_customers fc,
2378: hz_cust_acct_sites s,
2379: hz_cust_site_uses u
2380: WHERE
2381: fc.agreement_id = g_agreement_id