DBA Data[Home] [Help]

APPS.RCV_ACCRUALUTILITIES_GRP dependencies on PO_TAX_SV

Line 486: PO_TAX_SV.GET_TAX('PO', POD.PO_DISTRIBUTION_ID) *

482: IF l_dist_flag = 1 THEN
483: /* Bug 6266340: Modified the Select clause to check for 0 primary quantity */
484: SELECT decode(RT.primary_quantity, 0, 0,
485: ((PLL.price_override * RT.source_doc_quantity +
486: PO_TAX_SV.GET_TAX('PO', POD.PO_DISTRIBUTION_ID) *
487: RT.SOURCE_DOC_QUANTITY/POD.QUANTITY_ORDERED) *
488: decode (nvl(PLL.match_option,'P'),
489: 'R',NVL(RT.currency_conversion_rate,1),
490: 'P',NVL(NVL(POD.rate,POH.rate),1)) *

Line 511: NVL(SUM(PO_TAX_SV.get_tax('PO', POD.PO_DISTRIBUTION_ID)), 0)

507:
508: ELSE
509: l_stmt_num := 120;
510: SELECT
511: NVL(SUM(PO_TAX_SV.get_tax('PO', POD.PO_DISTRIBUTION_ID)), 0)
512: INTO
513: l_tax
514: from
515: po_distributions_all pod,