DBA Data[Home] [Help]

APPS.POR_VIEW_REQS_PKG dependencies on FND_CURRENCY

Line 913: select to_char(0, fnd_currency.safe_get_format_mask(currency_code, 30))

909: from po_requisition_lines_all
910: where requisition_line_id = req_line_id;
911:
912: if (cancelled = 'Y') then
913: select to_char(0, fnd_currency.safe_get_format_mask(currency_code, 30))
914: into value
915: from sys.dual;
916: else
917: select prl.unit_price * (prl.quantity - nvl(prl.quantity_cancelled,0))

Line 922: select to_char(total, fnd_currency.safe_get_format_mask(currency_code, 30))

918: into total
919: from po_requisition_lines_all prl
920: where requisition_line_id = req_line_id;
921:
922: select to_char(total, fnd_currency.safe_get_format_mask(currency_code, 30))
923: into value
924: from sys.dual;
925: end if;
926: