DBA Data[Home] [Help]

APPS.CST_PACEAMCOST_GRP dependencies on PO_TAX_SV

Line 1463: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),

1459:
1460: CURSOR c_pda IS
1461: SELECT ROUND(SUM(decode(NVL(pla.order_type_lookup_code,'QUANTITY'),
1462: 'RATE',NVL(cedit.amount,0) - (NVL(pda.amount_cancelled,0)
1463: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),
1464: 'FIXED PRICE',NVL(cedit.amount,0) - (NVL(pda.amount_cancelled,0)
1465: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),
1466: NVL(plla.price_override,0) *
1467: (NVL(pda.quantity_ordered,0) - NVL(pda.quantity_cancelled,0)

Line 1465: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),

1461: SELECT ROUND(SUM(decode(NVL(pla.order_type_lookup_code,'QUANTITY'),
1462: 'RATE',NVL(cedit.amount,0) - (NVL(pda.amount_cancelled,0)
1463: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),
1464: 'FIXED PRICE',NVL(cedit.amount,0) - (NVL(pda.amount_cancelled,0)
1465: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),
1466: NVL(plla.price_override,0) *
1467: (NVL(pda.quantity_ordered,0) - NVL(pda.quantity_cancelled,0)
1468: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id)) * NVL(cedit.currency_rate,1))
1469: ), l_ext_precision

Line 1468: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id)) * NVL(cedit.currency_rate,1))

1464: 'FIXED PRICE',NVL(cedit.amount,0) - (NVL(pda.amount_cancelled,0)
1465: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id))* NVL(cedit.currency_rate,1),
1466: NVL(plla.price_override,0) *
1467: (NVL(pda.quantity_ordered,0) - NVL(pda.quantity_cancelled,0)
1468: + /* Tax */ PO_TAX_SV.get_tax('PO',pda.po_distribution_id)) * NVL(cedit.currency_rate,1))
1469: ), l_ext_precision
1470: ) pda_value,
1471: pda.wip_operation_seq_num operation_seq_num,
1472: pla.category_id category_id,