APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on POR_VIEW_REQS_PKG

Line 6259: decode(prl.unit_price, 0, 0, decode(prl.matching_basis, 'AMOUNT',nvl(pcr3.new_amount, prl.amount) * por_view_reqs_pkg.get_line_nonrec_tax_total(

6255: aname => 'FUNCTIONAL_CURRENCY');
6256:
6257: x_progress :='001';
6258: select nvl(sum(nvl(decode(pcr4.action_type, 'CANCELLATION', 0,
6259: decode(prl.unit_price, 0, 0, decode(prl.matching_basis, 'AMOUNT',nvl(pcr3.new_amount, prl.amount) * por_view_reqs_pkg.get_line_nonrec_tax_total(
6260: prl.requisition_line_id)/prl.amount,
6261: nvl(pcr1.new_price, prl.unit_price)*
6262: nvl(pcr2.new_quantity, prl.quantity)*
6263: por_view_reqs_pkg.get_line_nonrec_tax_total(

Line 6263: por_view_reqs_pkg.get_line_nonrec_tax_total(

6259: decode(prl.unit_price, 0, 0, decode(prl.matching_basis, 'AMOUNT',nvl(pcr3.new_amount, prl.amount) * por_view_reqs_pkg.get_line_nonrec_tax_total(
6260: prl.requisition_line_id)/prl.amount,
6261: nvl(pcr1.new_price, prl.unit_price)*
6262: nvl(pcr2.new_quantity, prl.quantity)*
6263: por_view_reqs_pkg.get_line_nonrec_tax_total(
6264: prl.requisition_line_id)/
6265: (prl.unit_price*prl.quantity)))),0)),0),
6266: nvl(sum(decode(pcr4.action_type, 'CANCELLATION', 0, decode(prl.matching_basis, 'AMOUNT', nvl(pcr3.new_amount, prl.amount),
6267: nvl(pcr1.new_price, prl.unit_price)*