APPS.JAI_ENCUM_PRC dependencies on JAI_CMN_TAXES_ALL

Line 156: JAI_CMN_TAXES_ALL TAX_CODE,

152: ((100-nvl(tax_code.mod_cr_percentage,0))/100),1 )*
153: DECODE(po_tax.currency,'INR',1/nvl(poh.rate,1),1) ),0)
154: INTO ln_nr_tot_tax
155: FROM JAI_PO_TAXES PO_TAX,
156: JAI_CMN_TAXES_ALL TAX_CODE,
157: PO_HEADERS_ALL POH,
158: PO_LINE_LOCATIONS_ALL POLL
159: WHERE po_tax.line_location_id = poll.line_location_id
160: AND poll.po_header_id = poh.po_header_id

Line 171: , jai_cmn_taxes_all tax_code

167: (NVL(tax_code.mod_cr_percentage,0)/100))*
168: DECODE( po_tax.currency, 'INR', 1/NVL(poh.rate,1), 1) ), 0)
169: INTO ln_rec_tot_inclu_tax
170: FROM jai_po_taxes po_tax
171: , jai_cmn_taxes_all tax_code
172: , po_headers_all poh
173: , po_line_locations_all poll
174: WHERE po_tax.line_location_id = poll.line_location_id
175: AND poll.po_header_id = poh.po_header_id

Line 212: JAI_CMN_TAXES_ALL TAX_CODE,

208: DECODE(po_tax.currency,'INR',1/nvl(poh.rate,1),1)*
209: ( dist.quantity_ordered / poll.quantity )),2),0)
210: INTO p_nr_tax_tbl(i)
211: FROM JAI_PO_TAXES PO_TAX,
212: JAI_CMN_TAXES_ALL TAX_CODE,
213: PO_HEADERS_ALL POH,
214: PO_DISTRIBUTIONS_ALL DIST,
215: PO_LINE_LOCATIONS_ALL POLL
216: WHERE po_tax.line_location_id = dist.line_location_id

Line 229: , jai_cmn_taxes_all tax_code

225: DECODE( po_tax.currency, 'INR',1/NVL(poh.rate,1), 1)*
226: (dist.quantity_ordered/poll.quantity)), 2), 0)
227: INTO ln_rec_tax_inclu
228: FROM jai_po_taxes po_tax
229: , jai_cmn_taxes_all tax_code
230: , po_headers_all poh
231: , po_distributions_all dist
232: , po_line_locations_all poll
233: WHERE po_tax.line_location_id = dist.line_location_id

Line 290: JAI_CMN_TAXES_ALL TAX_CODE,

286: nvl(req_tax.modvat_flag,'Y'),((100-nvl(tax_code.mod_cr_percentage,0))/100),1 )*
287: DECODE(req_tax.currency,'INR',1/nvl(lines.rate, 1), 1 ) ),0)
288: INTO ln_nr_tot_tax
289: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
290: JAI_CMN_TAXES_ALL TAX_CODE,
291: PO_REQUISITION_LINES_ALL lines
292: WHERE req_tax.requisition_line_id = lines.requisition_line_id
293: AND req_tax.requisition_header_id = lines.requisition_header_id
294: AND req_tax.tax_id = tax_code.tax_id

Line 304: , jai_cmn_taxes_all tax_code

300: NVL(req_tax.modvat_flag,'Y'), 1, (NVL(tax_code.mod_cr_percentage,0)/100))*
301: DECODE( req_tax.currency, 'INR',1/nvl(lines.rate, 1), 1 ) ), 0)
302: INTO ln_rec_tot_inclu_tax
303: FROM jai_po_req_line_taxes req_tax
304: , jai_cmn_taxes_all tax_code
305: , po_requisition_lines_all lines
306: WHERE req_tax.requisition_line_id = lines.requisition_line_id
307: AND req_tax.requisition_header_id = lines.requisition_header_id
308: AND req_tax.tax_id = tax_code.tax_id

Line 343: JAI_CMN_TAXES_ALL TAX_CODE,

339: DECODE(req_tax.currency,'INR',1/nvl(lines.rate, 1), 1 ) *
340: (dist.req_line_quantity/lines.quantity)),2),0)
341: INTO p_nr_tax_tbl(i)
342: FROM JAI_PO_REQ_LINE_TAXES Req_TAX,
343: JAI_CMN_TAXES_ALL TAX_CODE,
344: PO_REQ_DISTRIBUTIONS_ALL dist,
345: PO_REQUISITION_LINES_ALL lines
346: WHERE req_tax.requisition_line_id = lines.requisition_line_id
347: AND req_tax.requisition_header_id = lines.requisition_header_id

Line 360: , jai_cmn_taxes_all tax_code

356: DECODE( req_tax.currency, 'INR',1/nvl(lines.rate, 1), 1 ) *
357: (dist.req_line_quantity/lines.quantity)), 2), 0)
358: INTO ln_rec_tax_inclu
359: FROM jai_po_req_line_taxes req_tax
360: , jai_cmn_taxes_all tax_code
361: , po_req_distributions_all dist
362: , po_requisition_lines_all lines
363: WHERE req_tax.requisition_line_id = lines.requisition_line_id
364: AND req_tax.requisition_header_id = lines.requisition_header_id