1340:
1341: BEGIN
1342:
1343: select decode(poll.match_option, 'P',NVL(pod.rate,1),
1344: gl_currency_api.get_rate(poh.currency_code, gsb.currency_code,
1345: trunc(p_wo_date),poh.rate_type)
1346: )
1347: into l_wo_cr
1348: from po_distributions_all pod,
1355: and poll.line_location_id = pod.line_location_id
1356: and gsb.set_of_books_id = pod.set_of_books_id ;
1357:
1358: EXCEPTION
1359: WHEN gl_currency_api.NO_RATE THEN
1360:
1361: Select NVL(pod.rate,1),
1362: pod.rate_date
1363: into l_wo_cr,