APPS.JAI_PO_HOOK_PKG dependencies on JAI_PO_REQ_LINE_TAXES

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

1176: ) RETURN NUMBER IS
1177: /* Get the requisition tax amount for each requisition line currency code wise*/
1178: CURSOR c_reqn_tax_amt IS
1179: SELECT rtl.requisition_line_id, rtl.currency, rtl.tax_amount, nvl(tax.rounding_factor, 0) rnd_factor
1180: FROM JAI_PO_REQ_LINE_TAXES rtl, JAI_CMN_TAXES_ALL tax , po_requisition_lines_all porl
1181: WHERE rtl.requisition_header_id = p_header_id
1182: AND (rtl.requisition_line_id = p_line_id OR p_line_id IS NULL)
1183: AND porl.requisition_line_id = rtl.requisition_line_id
1184: /*Bug 14031501 - Added check on modified_by_agent_flag to exclude tax of the parent line in case Requisition has been split*/

Line 1577: FROM JAI_PO_REQ_LINE_TAXES

1573: ) RETURN NUMBER IS
1574: /* Get the requisition tax amount for each requisition line currency code wise*/
1575: CURSOR c_reqn_tax_amt IS
1576: SELECT requisition_line_id, currency, SUM(tax_amount) tax_amount
1577: FROM JAI_PO_REQ_LINE_TAXES
1578: WHERE requisition_header_id = p_header_id
1579: AND requisition_line_id = p_line_id
1580: GROUP BY requisition_line_id, currency;
1581: /* Get the conversion rate for the currency code for the requisition line */

Line 2308: jai_po_req_line_taxes rtl

2304: , rtl.currency
2305: , rtl.tax_amount
2306: , NVL(tax.rounding_factor, 0) rnd_factor
2307: FROM
2308: jai_po_req_line_taxes rtl
2309: , jai_cmn_taxes_all tax
2310: , po_requisition_lines_all prla
2311: WHERE rtl.requisition_header_id = pn_header_id
2312: AND (rtl.requisition_line_id = pn_line_id OR pn_line_id IS NULL)