APPS.FUN_NET_ARAP_PKG dependencies on FUN_NET_CUSTOMERS_ALL

Line 505: fun_net_customers_all fnc ';

501: l_trx_from_clause :=
502: ' FROM ra_customer_trx_all rct,
503: ar_payment_schedules_all arps,
504: ra_cust_trx_types_all rctt,
505: fun_net_customers_all fnc ';
506: fun_net_util.Log_String(g_state_level,l_path,'FROM : '||l_trx_from_clause);
507: -- Build the WHERE clause --
508: /* Only select the transactions where the due date is on or before the Tnx due date in the batch */
509: /* Only select transactions where the tnx due date is between the start and end date of the agreement */

Line 3047: FROM fun_net_customers_all fc,

3043:
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

Line 3057: FROM fun_net_customers_all fc1

3053: AND s.cust_acct_site_id = u.cust_acct_site_id
3054: AND ((u.site_use_id = fc.cust_site_use_id AND (u.primary_flag='Y'
3055: OR (fc.cust_site_use_id = (
3056: SELECT min(fc1.cust_site_use_id)
3057: FROM fun_net_customers_all fc1
3058: WHERE fc1.agreement_id = fc.agreement_id
3059: AND fc1.cust_site_use_id is not null
3060: AND fc1.cust_account_id = p_cust_acct_id
3061: )