eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEX_COLL_IND dependencies on GL_SETS_OF_BOOKS

Line 1612: from gl_sets_of_books a,

1608: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_debit_memos_value),0) +
1609: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1610: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0))
1611: INTO l_amount_due_org
1612: from gl_sets_of_books a,
1613: ar_system_parameters b,
1614: ar_trx_summary c,
1615: hz_cust_accounts d
1616: where a.set_of_books_id = b.set_of_books_id

Line 1631: from gl_sets_of_books a,

1627: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_debit_memos_value),0) +
1628: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1629: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0))
1630: INTO l_amount_due_org
1631: from gl_sets_of_books a,
1632: ar_system_parameters b,
1633: ar_trx_summary c
1634: where a.set_of_books_id = b.set_of_books_id
1635: and b.org_id = c.org_id

Line 1648: from gl_sets_of_books a,

1644: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_debit_memos_value),0) +
1645: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1646: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0))
1647: INTO l_amount_due_org
1648: from gl_sets_of_books a,
1649: ar_system_parameters b,
1650: ar_trx_summary c
1651: where a.set_of_books_id = b.set_of_books_id
1652: and b.org_id = c.org_id

Line 1679: from gl_sets_of_books a,

1675: IF p_party_id IS NOT NULL THEN
1676: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1677: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
1678: INTO l_adj_total
1679: from gl_sets_of_books a,
1680: ar_system_parameters b,
1681: ar_trx_summary c,
1682: hz_cust_accounts d
1683: where a.set_of_books_id = b.set_of_books_id

Line 1692: from gl_sets_of_books a,

1688: ELSE IF p_cust_account_id IS NOT NULL THEN
1689: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1690: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
1691: INTO l_adj_total
1692: from gl_sets_of_books a,
1693: ar_system_parameters b,
1694: ar_trx_summary c
1695: where a.set_of_books_id = b.set_of_books_id
1696: and b.org_id = c.org_id

Line 1703: from gl_sets_of_books a,

1699: ELSE IF p_customer_site_use_id IS NOT NULL THEN
1700: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1701: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
1702: INTO l_adj_total
1703: from gl_sets_of_books a,
1704: ar_system_parameters b,
1705: ar_trx_summary c
1706: where a.set_of_books_id = b.set_of_books_id
1707: and b.org_id = c.org_id

Line 1745: from gl_sets_of_books a,

1741: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)+
1742: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1743: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_credit_memos_value),0))
1744: INTO l_amount_due_rem
1745: from gl_sets_of_books a,
1746: ar_system_parameters b,
1747: ar_trx_summary c,
1748: hz_cust_accounts d
1749: where a.set_of_books_id = b.set_of_books_id

Line 1770: from gl_sets_of_books a,

1766: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)+
1767: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1768: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_credit_memos_value),0))
1769: INTO l_amount_due_rem
1770: from gl_sets_of_books a,
1771: ar_system_parameters b,
1772: ar_trx_summary c
1773: where a.set_of_books_id = b.set_of_books_id
1774: and b.org_id = c.org_id

Line 1793: from gl_sets_of_books a,

1789: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)+
1790: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1791: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_credit_memos_value),0))
1792: INTO l_amount_due_rem
1793: from gl_sets_of_books a,
1794: ar_system_parameters b,
1795: ar_trx_summary c
1796: where a.set_of_books_id = b.set_of_books_id
1797: and b.org_id = c.org_id

Line 1834: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a, hz_cust_accounts d

1830: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
1831: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1832: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
1833: INTO l_tot_rec
1834: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a, hz_cust_accounts d
1835: where b.set_of_books_id = a.set_of_books_id
1836: AND c.cust_account_id = d.cust_account_id
1837: AND d.party_id = p_party_id
1838: and c.org_id = b.org_id;

Line 1859: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d

1855: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)-
1856: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1857: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
1858: INTO l_tot_sales_in_year
1859: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d
1860: WHERE c.org_id = b.org_id
1861: AND c.cust_account_id = d.cust_account_id
1862: AND d.party_id = p_party_id
1863: AND b.set_of_books_id = a.set_of_books_id

Line 1880: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

1876: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
1877: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1878: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
1879: INTO l_tot_rec
1880: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
1881: where b.set_of_books_id = a.set_of_books_id
1882: AND c.cust_account_id = p_cust_account_id
1883: and c.org_id = b.org_id;
1884:

Line 1904: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

1900: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)-
1901: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1902: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
1903: INTO l_tot_sales_in_year
1904: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
1905: WHERE c.org_id = b.org_id
1906: AND c.cust_account_id = p_cust_account_id
1907: AND b.set_of_books_id = a.set_of_books_id
1908: and as_of_date between TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 1923: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

1919: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
1920: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1921: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
1922: INTO l_tot_rec
1923: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
1924: where b.set_of_books_id = a.set_of_books_id
1925: AND c.site_use_id = p_customer_site_use_id
1926: and c.org_id = b.org_id;
1927:

Line 1947: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

1943: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_cash_receipts_value),0)-
1944: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
1945: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
1946: INTO l_tot_sales_in_year
1947: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
1948: WHERE c.org_id = b.org_id
1949: AND c.site_use_id = p_customer_site_use_id
1950: AND b.set_of_books_id = a.set_of_books_id
1951: and as_of_date between TRUNC(add_months(sysdate, -12)) AND TRUNC(sysdate);

Line 2035: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b , hz_cust_accounts d

2031: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2032: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0)+
2033: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2034: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0)) amount ,to_char(c.as_of_date,'MM') month
2035: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b , hz_cust_accounts d
2036: WHERE c.cust_account_id = d.cust_account_id
2037: AND d.party_id = p_party_id
2038: and c.org_id = b.org_id
2039: AND b.set_of_books_id = a.set_of_books_id

Line 2054: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2050: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2051: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0)+
2052: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2053: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0)) amount ,to_char(c.as_of_date,'MM') month
2054: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2055: WHERE c.cust_account_id = p_cust_account_id
2056: and c.org_id = b.org_id
2057: AND b.set_of_books_id = a.set_of_books_id
2058: AND c.as_of_date between TRUNC(sysdate-365) AND TRUNC(sysdate)

Line 2072: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2068: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2069: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_chargeback_value),0)+
2070: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2071: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0)) amount ,to_char(c.as_of_date,'MM') month
2072: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2073: WHERE c.site_use_id = p_customer_site_use_id
2074: and c.org_id = b.org_id
2075: AND b.set_of_books_id = a.set_of_books_id
2076: AND c.as_of_date between TRUNC(sysdate-365) AND TRUNC(sysdate)

Line 2230: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a,hz_cust_accounts d

2226: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
2227: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2228: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
2229: INTO l_op_bal
2230: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a,hz_cust_accounts d
2231: where c.cust_account_id = d.cust_account_id
2232: AND d.party_id = p_party_id
2233: AND b.set_of_books_id = a.set_of_books_id
2234: and c.org_id = b.org_id;

Line 2249: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

2245: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
2246: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2247: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
2248: INTO l_op_bal
2249: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
2250: where c.cust_account_id= p_cust_account_id
2251: AND b.set_of_books_id = a.set_of_books_id
2252: and c.org_id = b.org_id;
2253: ELSE IF p_customer_site_use_id IS NOT NULL THEN

Line 2267: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a

2263: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_bills_receivables_value),0)+
2264: nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2265: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.op_credit_memos_value),0)))
2266: INTO l_op_bal
2267: from ar_trx_bal_summary c, ar_system_parameters b, gl_sets_of_books a
2268: where c.site_use_id = p_customer_site_use_id
2269: AND b.set_of_books_id = a.set_of_books_id
2270: and c.org_id = b.org_id;
2271: END IF;

Line 2291: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d

2287: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_bills_receivables_value),0)+
2288: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2289: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
2290: INTO l_tot_bal
2291: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b, hz_cust_accounts d
2292: WHERE c.cust_account_id = d.cust_account_id
2293: AND d.party_id = p_party_id
2294: and c.org_id = b.org_id
2295: AND b.set_of_books_id = a.set_of_books_id

Line 2311: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2307: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_bills_receivables_value),0)+
2308: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2309: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
2310: INTO l_tot_bal
2311: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2312: WHERE c.cust_account_id = p_cust_account_id
2313: and c.org_id = b.org_id
2314: AND b.set_of_books_id = a.set_of_books_id
2315: and as_of_date between (trunc(sysdate) - b.cer_dso_days) AND TRUNC(sysdate);

Line 2330: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b

2326: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_bills_receivables_value),0)+
2327: NVL(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2328: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.total_adjustments_value),0))
2329: INTO l_tot_bal
2330: FROM gl_sets_of_books a, ar_trx_summary c, ar_system_parameters b
2331: WHERE c.site_use_id = p_customer_site_use_id
2332: and c.org_id = b.org_id
2333: AND b.set_of_books_id = a.set_of_books_id
2334: and as_of_date between (trunc(sysdate) - b.cer_dso_days) AND TRUNC(sysdate);

Line 2448: from gl_sets_of_books a,

2444: IF p_party_id IS NOT NULL THEN
2445: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2446: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_count),0))
2447: INTO l_nsf_count
2448: from gl_sets_of_books a,
2449: ar_system_parameters b,
2450: ar_trx_summary c,
2451: hz_cust_accounts d
2452: where a.set_of_books_id = b.set_of_books_id

Line 2461: from gl_sets_of_books a,

2457: ELSE IF p_cust_account_id IS NOT NULL THEN
2458: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2459: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_count),0))
2460: INTO l_nsf_count
2461: from gl_sets_of_books a,
2462: ar_system_parameters b,
2463: ar_trx_summary c
2464: where a.set_of_books_id = b.set_of_books_id
2465: and b.org_id = c.org_id

Line 2472: from gl_sets_of_books a,

2468: ELSE IF p_customer_site_use_id IS NOT NULL THEN
2469: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2470: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_count),0))
2471: INTO l_nsf_count
2472: from gl_sets_of_books a,
2473: ar_system_parameters b,
2474: ar_trx_summary c
2475: where a.set_of_books_id = b.set_of_books_id
2476: and b.org_id = c.org_id

Line 2502: from gl_sets_of_books a,

2498: IF p_party_id IS NOT NULL THEN
2499: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2500: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
2501: INTO l_nsf_amount
2502: from gl_sets_of_books a,
2503: ar_system_parameters b,
2504: ar_trx_summary c,
2505: hz_cust_accounts d
2506: where a.set_of_books_id = b.set_of_books_id

Line 2515: from gl_sets_of_books a,

2511: ELSE IF p_cust_account_id IS NOT NULL THEN
2512: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2513: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
2514: INTO l_nsf_amount
2515: from gl_sets_of_books a,
2516: ar_system_parameters b,
2517: ar_trx_summary c
2518: where a.set_of_books_id = b.set_of_books_id
2519: and b.org_id = c.org_id

Line 2526: from gl_sets_of_books a,

2522: ELSE IF p_customer_site_use_id IS NOT NULL THEN
2523: select sum(nvl(gl_currency_api.convert_amount(c.currency,a.currency_code,sysdate,
2524: fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'),c.nsf_stop_payment_amount),0))
2525: INTO l_nsf_amount
2526: from gl_sets_of_books a,
2527: ar_system_parameters b,
2528: ar_trx_summary c
2529: where a.set_of_books_id = b.set_of_books_id
2530: and b.org_id = c.org_id

Line 2559: FROM gl_sets_of_books a,

2555: SELECT ROUND(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE, fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT_DAYS_LATE,0)))) /
2556: DECODE(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0)))),0,1,
2557: SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0))))),2)
2558: INTO l_wt_days_paid_late
2559: FROM gl_sets_of_books a,
2560: ar_system_parameters b ,
2561: ar_trx_summary c ,
2562: hz_cust_accounts d
2563: WHERE a.set_of_books_id = b.set_of_books_id

Line 2573: FROM gl_sets_of_books a,

2569: SELECT ROUND(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE, fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT_DAYS_LATE,0)))) /
2570: DECODE(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0)))),0,1,
2571: SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0))))),2)
2572: INTO l_wt_days_paid_late
2573: FROM gl_sets_of_books a,
2574: ar_system_parameters b ,
2575: ar_trx_summary c
2576: -- , hz_cust_accounts d commented for Bug14167214 by bibeura
2577: WHERE a.set_of_books_id = b.set_of_books_id

Line 2586: FROM gl_sets_of_books a,

2582: SELECT ROUND(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE, fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT_DAYS_LATE,0)))) /
2583: DECODE(SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0)))),0,1,
2584: SUM(gl_currency_api.convert_amount(c.currency,a.currency_code, SYSDATE,fnd_profile.value('IEX_EXCHANGE_RATE_TYPE'), (NVL(SUM_APP_AMT,0))))),2)
2585: INTO l_wt_days_paid_late
2586: FROM gl_sets_of_books a,
2587: ar_system_parameters b ,
2588: ar_trx_summary c
2589: -- , hz_cust_accounts d commented for Bug14167214 by bibeura
2590: WHERE a.set_of_books_id = b.set_of_books_id

Line 2618: gl_sets_of_books sob,

2614: INTO g_curr_rec.base_currency,
2615: g_curr_rec.base_precision,
2616: g_curr_rec.base_min_acc_unit
2617: FROM ar_system_parameters sysp,
2618: gl_sets_of_books sob,
2619: fnd_currencies c
2620: WHERE sob.set_of_books_id = sysp.set_of_books_id
2621: AND sob.currency_code = c.currency_code;
2622: