APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 946: from JAI_PO_LINE_LOCATIONS jpoll

942:
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*/

Line 1757: update JAI_PO_LINE_LOCATIONS set service_type_code = rec.service_type_code

1753: -- Update the transaction tables with the service type code based on source value
1754: --
1755: if rec.transaction_source in ('PURCHASING','RECEIVING') then
1756:
1757: update JAI_PO_LINE_LOCATIONS set service_type_code = rec.service_type_code
1758: , last_update_date = sysdate
1759: , last_updated_by = lv_user_id
1760: , last_update_login = lv_login_id
1761: where po_header_id = rec.document_id