APPS.BEN_MAINTAIN_BENEFIT_ACTIONS SQL Statements

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

Line: 19

    select /*+ index(ran BEN_BATCH_RANGES_CK) */
           ran.rowid,
           ran.starting_person_action_id,
           ran.ending_person_action_id
    from   ben_batch_ranges ran
    where  ran.range_status_cd = 'U'
    and    ran.benefit_action_id = c_bft_id
    and    rownum < 2
    for    update of ran.range_status_cd;

Line: 45

    update ben_batch_ranges ran
    set    ran.range_status_cd = 'P'
    where  ran.rowid = l_rowid;

Line: 71

  ,p_person_selection_rule_id in number
  ,p_comp_selection_rule_id   in number
  ,p_derivable_factors        in varchar2
  ,p_cbr_tmprl_evt_flag       in varchar2
  ,p_lf_evt_ocrd_dt           in varchar2
  ,p_lmt_prpnip_by_org_flag   in varchar2
  ,p_gsp_eval_elig_flag       in varchar2 default null  -- GSP Rate Sync : Evaluate Eligibility
  ,p_lf_evt_oper_cd           in varchar2 default null  -- GSP Rate Sync : Life Event Operation code
  )
is
  --
  l_package        varchar2(80) := g_package||'.start_slaves';

Line: 117

         argument16  => p_person_selection_rule_id,
         argument17  => p_comp_selection_rule_id,
         argument18  => p_derivable_factors,
         argument19  => l_count,
         argument20  => p_lf_evt_ocrd_dt,
         argument21  => p_cbr_tmprl_evt_flag,
         argument22  => p_lmt_prpnip_by_org_flag,
         argument23  => p_gsp_eval_elig_flag,          -- GSP Rate Sync : Evaluate Eligibility
         argument24  => p_lf_evt_oper_cd               -- GSP Rate Sync : Life Event Operation code
         );

Line: 162

    select phase_code,
           status_code
    from   fnd_concurrent_requests fnd
    where  fnd.request_id = c_request_id;

Line: 245

    select 'Y'
    from   ben_benefit_actions bft
    where  bft.benefit_action_id = p_benefit_action_id
    and    bft.request_id = fnd_global.conc_request_id;

Line: 251

    select count(*)
    from   ben_person_actions pac
    where  pac.benefit_action_id = p_benefit_action_id
    and    pac.action_status_cd = nvl(p_status_cd,pac.action_status_cd);

Line: 371

    select pact.person_id,
           pact.person_action_id,
           pact.object_version_number,
           pact.ler_id
    from   ben_person_actions pact
    where  pact.benefit_action_id = c_bft_id
    and    pact.action_status_cd = 'U'
    and    pact.person_action_id
      between c_stpact_id and c_endpact_id;