APPS.POR_VIEW_REQS_PKG dependencies on DUAL

Line 149: from dual;

145: decode(l_address_line_2,null,'',l_address_line_2||' ')||
146: decode(l_address_line_3,null,'',l_address_line_3||' ')||
147: l_address_info
148: into value
149: from dual;
150:
151: return value;
152:
153: end if;

Line 915: from sys.dual;

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))
918: into total
919: from po_requisition_lines_all prl

Line 924: from sys.dual;

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:
927: return value;
928: end get_line_total;