APPS.IGI_CIS_IGIPMTHP_PKG SQL Statements

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

Line: 75

            pwhereclause := pwhereclause || ' AND hdr.header_id = (select max(header_id) from IGI_CIS_MTH_RET_HDR_T where period_name = ''' || p_period || '''';

Line: 78

            pwhereclause := pwhereclause || ' AND hdr.header_id = (select max(header_id) from IGI_CIS_MTH_RET_HDR_H where period_name = ''' || p_period || '''';

Line: 102

        partselect := ' '''' invoice_num, ';

Line: 105

        partselect := 'nvl((select invoice_num from ap_invoices where pay.invoice_id = invoice_id),'''') invoice_num, ';

Line: 127

      FND_FILE.PUT_LINE(FND_FILE.LOG,'partselect :' || partselect);

Line: 133

    log(C_STATE_LEVEL, l_procedure_name, 'partselect='||partselect);

Line: 148

      Select max(header_id) --Bug 5933093
      into l_header_id
      from igi_cis_mth_ret_hdr_t
      where period_name = p_period
      and request_status_code = 'P';

Line: 154

      delete from igi_cis_mth_ret_hdr_t where header_id = l_header_id;

Line: 155

      log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_hdr_t');

Line: 156

      delete from igi_cis_mth_ret_lines_t where header_id = l_header_id;

Line: 157

      log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_lines_t');

Line: 158

      delete from igi_cis_mth_ret_pay_t where header_id = l_header_id;

Line: 159

      log(C_STATE_LEVEL, l_procedure_name, 'Deleted '||SQL%ROWCOUNT||' rows from igi_cis_mth_ret_pay_t');

Line: 194

     SELECT start_date
       INTO l_start_date
       FROM ap_other_periods
      WHERE period_type = l_period_type
        AND period_name = p_period;

Line: 218

     SELECT end_date
       INTO l_end_date
       FROM ap_other_periods
      WHERE period_type = l_period_type
        AND period_name = p_period;

Line: 239

     SELECT meaning
       INTO l_print_type
       FROM igi_lookups
      WHERE lookup_type = 'IGI_CIS2007_PRINT_TYPES'
        AND lookup_code = p_print_type;

Line: 268

     SELECT name
       INTO l_org_name
       FROM hr_operating_units
      WHERE organization_id = l_org_id;

Line: 288

     SELECT meaning
       INTO l_sort_by
       FROM igi_lookups
      WHERE lookup_type='IGI_CIS2007_MTHR_SORT_COLS'
        AND lookup_code=p_sort_by;

Line: 309

      SELECT meaning
        INTO l_report_title
        FROM igi_lookups
       WHERE lookup_type = 'IGI_CIS2007_NEW_REPORTS'
         AND lookup_code = decode(p_mode||p_report_lev,'PS','IGIPMTPS',
                                                     'PD','IGIPMTPD',
                                                     'FD','IGIPMTRD',
                                                     'FS','IGIPMTRS');

Line: 338

    SELECT meaning
       INTO l_tax_status
       FROM igi_lookups
       WHERE lookup_type = 'IGI_CIS2007_TAX_STATUS'
       AND lookup_code = decode(nvl(p_awt_group_code,' '),l_gross_group,'G',
                                                 l_net_group,'N',
                                                 l_unmatch_group,'U');

Line: 367

      SELECT meaning
        INTO l_amt_type
        FROM igi_lookups
       WHERE lookup_type = 'IGI_CIS2007_MTH_RET_AMT_TYPE'
         AND lookup_code = nvl(p_amt_type,'P');