APPS.IGI_CIS2007_IGIPPADR_PKG SQL Statements

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

Line: 6

          p_select_clause := ' , (lines.total_payments + lines.total_deductions) GROSS_AMOUNT_PAID,' ||
                             ' lines.MATERIAL_COST MATERIAL_COST,' ||
                             ' lines.LABOUR_COST LABOUR_COST, ' ||
                             ' lines.TOTAL_DEDUCTIONS AMOUNT_DEDUCTED, ' ||
			     ' null INVOICE_NUM ' ;

Line: 35

          p_select_clause := ', (payment.amount + payment.total_deductions) GROSS_AMOUNT_PAID,' ||
                             ' payment.MATERIAL_COST MATERIAL_COST,' ||
                             ' payment.LABOUR_COST LABOUR_COST, ' ||
                             ' payment.TOTAL_DEDUCTIONS AMOUNT_DEDUCTED, ' ||
			     ' invoice.INVOICE_NUM INVOICE_NUM ' ;

Line: 71

        select meaning
          into l_print_type
          from IGI_LOOKUPS
         where LOOKUP_TYPE = 'IGI_CIS2007_PRINT_TYPES'
           and LOOKUP_CODE = P_PRINT_TYPE;

Line: 87

        select name
          into l_org_name
          from hr_operating_units
         where organization_id = l_org_id;

Line: 102

        select end_date
          into l_end_date
          from AP_OTHER_PERIODS
         where period_type = l_period_type
           and period_name = P_PERIOD;