APPS.JAI_PO_HOOK_PKG dependencies on JAI_PO_REQ_LINE_TAXES

Line 1065: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl

1061: ) RETURN NUMBER IS
1062: /* Get the requisition tax amount for each requisition line currency code wise*/
1063: CURSOR c_reqn_tax_amt IS
1064: SELECT rtl.requisition_line_id, rtl.currency, rtl.tax_amount, nvl(tax.rounding_factor, 0) rnd_factor
1065: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl
1066: WHERE rtl.requisition_header_id = p_header_id
1067: AND (rtl.requisition_line_id = p_line_id OR p_line_id IS NULL)
1068: AND porl.requisition_line_id = rtl.requisition_line_id
1069: AND tax.tax_id = rtl.tax_id

Line 1448: FROM JAI_PO_REQ_LINE_TAXES

1444: ) RETURN NUMBER IS
1445: /* Get the requisition tax amount for each requisition line currency code wise*/
1446: CURSOR c_reqn_tax_amt IS
1447: SELECT requisition_line_id, currency, SUM(tax_amount) tax_amount
1448: FROM JAI_PO_REQ_LINE_TAXES
1449: WHERE requisition_header_id = p_header_id
1450: AND requisition_line_id = p_line_id
1451: GROUP BY requisition_line_id, currency;
1452: /* Get the conversion rate for the currency code for the requisition line */

Line 2120: jai_po_req_line_taxes rtl

2116: , rtl.currency
2117: , rtl.tax_amount
2118: , NVL(tax.rounding_factor, 0) rnd_factor
2119: FROM
2120: jai_po_req_line_taxes rtl
2121: , jai_cmn_taxes_all tax
2122: , po_requisition_lines_all prla
2123: WHERE rtl.requisition_header_id = pn_header_id
2124: AND (rtl.requisition_line_id = pn_line_id OR pn_line_id IS NULL)