APPS.JAI_ENCUM_PRC dependencies on JAI_PO_REQ_LINE_TAXES

Line 338: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,

334: ,((100-nvl(tax_code.mod_cr_percentage,0))/100)
335: ,1 )
336: * DECODE(req_tax.currency,'INR',1,lines.rate) ),0)
337: INTO ln_nr_tot_tax
338: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
339: JAI_CMN_TAXES_ALL TAX_CODE,
340: PO_REQUISITION_LINES_ALL lines
341: WHERE req_tax.requisition_line_id = lines.requisition_line_id
342: AND req_tax.requisition_header_id = lines.requisition_header_id

Line 361: jai_po_req_line_taxes req_tax

357: ), 0)
358: INTO
359: ln_rec_tot_inclu_tax
360: FROM
361: jai_po_req_line_taxes req_tax
362: , jai_cmn_taxes_all tax_code
363: , po_requisition_lines_all lines
364: WHERE req_tax.requisition_line_id = lines.requisition_line_id
365: AND req_tax.requisition_header_id = lines.requisition_header_id

Line 413: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,

409: ,((100-nvl(tax_code.mod_cr_percentage,0))/100)
410: ,1 )
411: * DECODE(req_tax.currency,'INR',1,lines.rate) * (dist.req_line_quantity/lines.quantity)),2),0)
412: INTO p_nr_tax_tbl(i)
413: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
414: JAI_CMN_TAXES_ALL TAX_CODE,
415: PO_REQ_DISTRIBUTIONS_ALL dist,
416: PO_REQUISITION_LINES_ALL lines
417: WHERE req_tax.requisition_line_id = lines.requisition_line_id

Line 438: jai_po_req_line_taxes req_tax

434: ), 2), 0)
435: INTO
436: ln_rec_tax_inclu
437: FROM
438: jai_po_req_line_taxes req_tax
439: , jai_cmn_taxes_all tax_code
440: , po_req_distributions_all dist
441: , po_requisition_lines_all lines
442: WHERE req_tax.requisition_line_id = lines.requisition_line_id