DBA Data[Home] [Help]

APPS.JAI_TRX_REPO_EXTRACT_PKG dependencies on JAI_OM_OE_SO_TAXES

Line 1710: , JAI_OM_OE_SO_TAXES jstl

1706:
1707: cursor c_get_so_line_srvtyp (cp_line_id JAI_OM_OE_SO_LINES.line_id%type ) is
1708: select service_type_code, sum(jstl.tax_amount) service_tax_amount
1709: from JAI_OM_OE_SO_LINES jsl
1710: , JAI_OM_OE_SO_TAXES jstl
1711: , jai_cmn_taxes_all jtc
1712: where jsl.line_id = cp_line_id
1713: and jsl.line_id = jstl.line_id
1714: and jstl.tax_id = jtc.tax_id