APPS.JAI_AP_IL_ORG_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 75

       select 1 into l_invoice_id from dual
       where not exists ( select invoice_id from jai_ap_tds_invoices where invoice_id = P_INVOICE_ID );  -- :inv_sum_folder.invoice_id

Line: 83

       select
         0
       into
         l_invoice_id
       from
         ap_invoices_all
       where source = 'INDIA TDS'
         and invoice_num like '%TDS%'
         and invoice_id = P_INVOICE_ID;

Line: 122

  select 1 into v_misc_line from dual
  where exists (select 1 from ap_invoice_lines ap, jai_ap_invoice_lines jap
                where jap.invoice_id = P_INVOICE_ID --:INV_SUM_FOLDER.INVOICE_ID
                and   jap.line_type_lookup_code = P_LOOKUP_CODE --:LINE_SUM_FOLDER.LINE_TYPE_LOOKUP_CODE
                and   jap.invoice_line_number =  P_LINE_NUMBER --:LINE_SUM_FOLDER.LINE_NUMBER
                and   ap.invoice_id = jap.invoice_id
                and   jap.line_type_lookup_code ='MISCELLANEOUS'
                and   jap.invoice_line_number = ap.line_number);

Line: 156

  select 1 into v_check from dual
  where exists ( select 1 from jai_ap_invoice_lines jp where jp.invoice_id = P_INVOICE_ID and line_type_lookup_code ='MISCELLANEOUS' );

Line: 187

select tax_category_id from jai_ap_invoice_lines
where invoice_id =p_invoice_id
and invoice_line_number =p_line_number
and LINE_TYPE_LOOKUP_CODE = 'ITEM';

Line: 194

select tax_category_id from jai_cmn_vendor_sites where vendor_id =p_supplier_id
and vendor_site_id = p_supplier_site_id;