DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_PO_TAXES

Line 947: ,jai_po_taxes jpollt

943: cursor c_get_po_line_loc_srvtyp (cp_po_line_id po_lines_all.po_line_id%type )
944: is
945: select service_type_code, sum(jpollt.tax_amount) service_tax_amount
946: from JAI_PO_LINE_LOCATIONS jpoll
947: ,jai_po_taxes jpollt
948: where jpoll.po_line_id = cp_po_line_id
949: and jpollt.line_location_id = jpoll.line_location_id
950: /*added the cess and sh cess tax types for bug#6457710*/
951: 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)