DBA Data[Home] [Help]

APPS.ENG_BIS_FUNCTIONS SQL Statements

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

Line: 21

      SELECT calendar_code, calendar_exception_set_id
        FROM mtl_parameters
       WHERE organization_id = p_organization_id;
Line: 31

   SELECT count(*)
     INTO l_days
     FROM bom_calendar_dates
    WHERE calendar_code = l_calendar_code
      AND exception_set_id = l_exception_set_id
      AND calendar_date between p_start_date and p_end_date
      AND seq_num is not null;