APPS.PA_IMPL_OPTIONS_PUB SQL Statements

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

Line: 55

  UPDATE pa_implementations
     SET ENABLE_MRC_FOR_FUND_FLAG = 'U';

Line: 103

     SELECT include_gains_losses_flag
       FROM pa_projects_all
      WHERE org_id = p_org_id -- 5078716 , Removed nvl condition
        AND project_type = p_project_type
        AND include_gains_losses_flag = 'Y';

Line: 128

FUNCTION option_updateable(
  p_project_id IN NUMBER
 ,p_option_code VARCHAR2
 ) RETURN VARCHAR2 IS
  l_return_code   VARCHAR2(30) := 'Y';

Line: 184

END option_updateable;

Line: 210

  procedure Update_Access_level
  ( errbuf                     out NOCOPY varchar2, --File.Sql.39 bug 4440895
    retcode                    out NOCOPY varchar2, --File.Sql.39 bug 4440895
    p_from_project_number      in  varchar2 default null,
    p_to_project_number        in varchar2 default null,
    p_project_status           in varchar2 default null,
    p_project_type             in varchar2 default null,
    p_project_organization     in number default null,
    p_access_level             in varchar2 default '1'
  ) is

  cursor c_projects is
    select project_id
    from   pa_projects_all
    where  segment1                     >= nvl(p_from_project_number, segment1)
    and    segment1                     <= nvl(p_to_project_number, segment1)
    and    project_status_code          = nvl(p_project_status, project_status_code)
    and    project_type                 = nvl(p_project_type, project_type)
    and    carrying_out_organization_id = nvl(p_project_organization,carrying_out_organization_id);

Line: 232

  l_last_update_date date;

Line: 233

  l_last_updated_by number;

Line: 234

  l_last_update_login number;

Line: 238

    l_last_update_date := sysdate;

Line: 239

    l_last_updated_by  := fnd_global.user_id;

Line: 240

    l_last_update_login := fnd_global.user_id;

Line: 246

      update pa_projects_all
        set security_level      = to_number( p_access_level),
            last_update_date    = l_last_update_date,
            last_updated_by     = l_last_updated_by,
            last_update_login   = l_last_update_login
      where project_id = rec.project_id;

Line: 274

  end Update_Access_Level;

Line: 401

    SELECT 'x'
      FROM pa_lookups
     WHERE lookup_type = 'ASSET_ALLOCATION_METHOD'
       AND lookup_code = p_asset_allocation_method;

Line: 465

    SELECT 'x'
      FROM pa_lookups
     WHERE lookup_type = 'CAPITAL_EVENT_PROCESSING'
       AND lookup_code = p_capital_event_processing;

Line: 529

       SELECT  'X'
         FROM  pa_ind_rate_schedules_all_bg
        WHERE  IND_RATE_SCH_USAGE = 'CAPITALIZED_INTEREST'
          AND  trunc(sysdate) between START_DATE_ACTIVE
          AND  nvl(trunc(END_DATE_ACTIVE),trunc(sysdate))
          AND  IND_RATE_SCH_ID = p_cint_rate_sch_id ;