DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on POR_VIEW_REQS_PKG

Line 1994: por_view_reqs_pkg.get_line_nonrec_tax_total(

1990: select to_char(nvl(sum(nvl(decode(pcr3.action_type, 'CANCELLATION', 0,
1991: decode(prl.unit_price, 0, 0,
1992: nvl(pcr1.new_price, prl.unit_price)*
1993: nvl(pcr2.new_quantity, prl.quantity)*
1994: por_view_reqs_pkg.get_line_nonrec_tax_total(
1995: prl.requisition_line_id)/
1996: (prl.unit_price*prl.quantity))),0)),0),
1997: FND_CURRENCY.GET_FORMAT_MASK(l_currency_code,30))
1998: ||' '|| l_currency_code,