APPS.IGI_CIS2007_IGIPSUPR_PKG SQL Statements

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

Line: 84

      SELECT meaning
        INTO l_report_title
        FROM igi_lookups
       WHERE lookup_type = 'IGI_CIS2007_NEW_REPORTS'
         AND lookup_code = p_report;

Line: 104

      SELECT NAME
        INTO l_org_name
        FROM hr_operating_units
       WHERE organization_id = l_org_id;

Line: 120

      SELECT meaning
        INTO l_active_meaning
        FROM igi_lookups
       WHERE lookup_type = 'IGI_CIS2007_ACTIVE_TYPE'
         AND lookup_code = p_active;

Line: 143

      SELECT meaning
        INTO l_sortby_meaning
        FROM igi_lookups
       WHERE lookup_type = l_lookup_type
         AND lookup_code = p_sort_by;

Line: 164

      SELECT decode(sign(trunc(nvl(p_start_date, SYSDATE)) - trunc(SYSDATE)),
                    1,
                    'I',
                    decode(sign(trunc(nvl(p_end_date, SYSDATE)) -
                                trunc(SYSDATE)),
                           -1,
                           'I',
                           'A'))
        INTO l_active_flag
        FROM dual;

Line: 188

        SELECT 'VERIFIED'
            INTO verify_status
        FROM ap_suppliers
            WHERE vendor_id = l_vendor_id
            AND cis_verification_date > add_months(sysdate,-24)
            AND rownum = 1;

Line: 219

        SELECT 'PAID'
            INTO paid_status
        FROM ap_checks ac,
             ap_invoice_payments pay,
             -- Bug 5642198 Start
             ap_invoices inv,
             ap_supplier_sites pvs
             -- Bug 5642198 End
            WHERE ac.vendor_id = l_vendor_id
            AND ac.void_date IS NULL
            AND pay.check_id = ac.check_id
            AND accounting_date > add_months(tax_year_start, -24)
            -- Bug 5642198 Start
            AND inv.invoice_id = pay.invoice_id
            AND pvs.vendor_id = inv.vendor_id
            AND pvs.vendor_site_id = inv.vendor_site_id
            AND upper(pvs.allow_awt_flag) = 'Y'
            -- Bug 5642198 End
            AND rownum = 1;

Line: 253

        SELECT 'VERIFIED'
            INTO verify_status
        FROM ap_suppliers
            WHERE vendor_id = l_vendor_id
            AND cis_verification_date > add_months(sysdate,-24)
            AND rownum = 1;

Line: 273

        SELECT 'PAID'
            INTO paid_status
        FROM ap_checks ac,
             ap_invoice_payments pay,
             ap_invoices inv,
             ap_supplier_sites pvs
        WHERE ac.vendor_id = p_vendor_id
            AND ac.void_date IS NULL
            AND pay.check_id = ac.check_id
            AND accounting_date between p_start_date and p_end_date
            AND inv.invoice_id = pay.invoice_id
            AND pvs.vendor_id = inv.vendor_id
            AND pvs.vendor_site_id = inv.vendor_site_id
            AND pvs.allow_awt_flag = 'Y'
            AND rownum = 1;

Line: 300

         select 1 into v_tmp
         from igi_cis_mth_ret_hdr_h hdr, igi_cis_mth_ret_lines_h line
         where hdr.header_id = line.header_id
         and line.vendor_id = p_vendor_id
         and hdr.period_ending_date between p_start_date and p_end_date
         and rownum = 1;

Line: 315

      select upper(certificate_type) cert_type,nvl(end_date,sysdate) edt
      from ap_awt_tax_rates
      where vendor_id = p_vendor_id
      and upper(certificate_type) in ('CIS4T','CIS5','CIS6','CIS4P');