APPS.FUN_NET_ARAP_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 322: ' FROM ra_customer_trx_all rct,

318: sum(arps.amount_due_remaining) AS open_amount ' ;
319: fun_net_util.Log_String(g_state_level,l_path,'SELECT : '||l_trx_select_clause);
320:
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);

Line 1402: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart

1398: WHERE api.invoice_id = fnapi.invoice_id
1399: AND fnapi.batch_id = g_batch_id
1400: UNION
1401: SELECT INVOICE_CURRENCY_CODE
1402: FROM ra_customer_trx_all rct, fun_net_ar_txns_all fnart
1403: WHERE rct.customer_trx_id = fnart.customer_trx_id
1404: AND fnart.batch_id = g_batch_id;
1405:
1406: l_count NUMBER;

Line 1547: FROM ra_customer_trx_all rct, fnd_currencies fc

1543: l_inv_curr_net_amt(i) := ROUND(l_inv_curr_net_amt(i),l_precision);
1544: ELSIF p_appln = 'AR' THEN
1545: SELECT fc.currency_code,fc.precision
1546: INTO l_inv_currency,l_precision
1547: FROM ra_customer_trx_all rct, fnd_currencies fc
1548: WHERE rct.customer_trx_id = l_trx_id(i)
1549: AND rct.invoice_currency_code = fc.currency_code;
1550:
1551: l_inv_curr_net_amt(i) := l_amt_to_net * Derive_Net_Exchg_Rate(g_func_currency,l_inv_currency);

Line 1902: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar

1898: elsif (g_net_currency_rule = 'WITHIN_CURRENCY') then
1899:
1900: SELECT count (DISTINCT rac.invoice_currency_code)
1901: into l_count
1902: FROM ra_customer_trx_all rac,fun_net_ar_txns_all fnar
1903: WHERE rac.customer_trx_id = fnar.customer_trx_id
1904: AND fnar.batch_id = g_batch_id
1905: AND rac.invoice_currency_code <> g_func_currency;
1906: