DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_PO_TAXES

Line 1615: ,jai_po_taxes jpollt

1611: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
1612: is
1613: select service_type_code, sum(jpollt.tax_amount) service_tax_amount
1614: from JAI_PO_LINE_LOCATIONS jpoll
1615: ,jai_po_taxes jpollt
1616: where jpoll.po_line_id = cp_po_line_id
1617: and jpollt.line_location_id = jpoll.line_location_id
1618: /*added the cess and sh cess tax types for bug#6457710*/
1619: and jpollt.tax_type IN (jai_constants.tax_type_service,jai_constants.tax_type_service_edu_cess,jai_constants.tax_type_sh_service_edu_cess)