APPS.PO_WF_PO_NOTIFICATION dependencies on PO_DISTRIBUTIONS

Line 154: po_distributions pod

150: Old tax select:
151: SELECT nvl(sum(nonrecoverable_tax), 0)
152: INTO l_tax_amt
153: FROM po_lines pol,
154: po_distributions pod
155: WHERE pol.po_header_id = l_document_id
156: AND pod.po_line_id = pol.po_line_id;
157: */
158:

Line 213: po_distributions pod

209: ) * X_min_acct_unit
210: )
211: INTO l_tax_amt
212: FROM po_lines pol,
213: po_distributions pod
214: WHERE pol.po_header_id = l_document_id
215: AND pod.po_line_id = pol.po_line_id;
216: ELSE
217: SELECT sum( round (POD.nonrecoverable_tax *

Line 229: po_distributions pod

225: )
226: )
227: INTO l_tax_amt
228: FROM po_lines pol,
229: po_distributions pod
230: WHERE pol.po_header_id = l_document_id
231: AND pod.po_line_id = pol.po_line_id;
232: END IF;
233: END IF;--(lv_tax_region ='JAI')