APPS.OKI_BUT_PVT SQL Statements

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

Line: 30

  SELECT  INITCAP(RTRIM(TO_CHAR(rfh.program_update_date, 'MONTH')))
        , TO_CHAR(rfh.program_update_date,'DD, RRRR HH24:MI')
  FROM    oki_refreshs rfh
  WHERE   UPPER(rfh.object_name) = UPPER(p_name)
  ;

Line: 176

    SELECT glpr.period_name period_name
    FROM   gl_periods glpr
    WHERE  p_period_set_name = glpr.period_set_name
    AND    p_period_type     = glpr.period_type
    AND    glpr.adjustment_period_flag = 'N'
    AND    p_default_date    BETWEEN TRUNC(glpr.start_date)
                                 AND TRUNC(glpr.end_date)
    ;

Line: 493

    SELECT oru.name
    FROM hr_all_organization_units oru
    WHERE oru.organization_id = p_org_id
    ;