APPS.BEN_BENBOSUM_XMLP_PKG SQL Statements

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

Line: 13

  l_just_programs              hr_lookups.meaning%type ;   l_comp_object_selection_rule ff_formulas_f.formula_name%type ;

Line: 14

  l_person_selection_rule      ff_formulas_f.formula_name%type ;

Line: 41

     p_comp_object_selection_rule => L_COMP_OBJECT_SELECTION_RULE,
     p_person_selection_rule      => L_PERSON_SELECTION_RULE,
     p_life_event_reason          => L_LIFE_EVENT_REASON,
     p_organization               => L_ORGANIZATION,
     p_postal_zip_range           => L_POSTAL_ZIP_RANGE,
     p_reporting_group            => L_REPORTING_GROUP,
     p_plan_type                  => L_PLAN_TYPE,
     p_option                     => L_OPTION,
     p_eligibility_profile        => L_ELIGIBILITY_PROFILE,
     p_variable_rate_profile      => L_VARIABLE_RATE_PROFILE,
     p_legal_entity               => L_LEGAL_ENTITY,
     p_payroll                    => L_PAYROLL,
     p_status                     => L_STATUS);

Line: 64

                select name into CP_PERSON_BNFT_GRP
    from ben_benfts_grp a,
         ben_benefit_actions b
    where a.benfts_grp_id = b.benfts_grp_id
    and    b.request_id = P_CONCURRENT_REQUEST_ID;

Line: 75

                select location_code into CP_LOCATION
    from hr_locations a,
          ben_benefit_actions b
    where a.location_id = b.location_id
    and    b.request_id = P_CONCURRENT_REQUEST_ID;

Line: 86

                select date_from, uneai_effective_date into CP_FROM_OCRD_DT, CP_TO_OCRD_DT
    from  ben_benefit_actions
    where request_id = P_CONCURRENT_REQUEST_ID;

Line: 94

                select hl.meaning into CP_RESULTING_STATUS
    from  ben_benefit_actions bft, hr_lookups hl
      where bft.PTNL_LER_FOR_PER_STAT_CD = hl.lookup_code
      and hl.lookup_type = 'BEN_PTNL_LER_FOR_PER_STAT'
      and bft.request_id = P_CONCURRENT_REQUEST_ID;

Line: 110

        select count(distinct rpt.person_id)
  into   CP_PEOPLE_LF_EVT_BO
  from   ben_reporting rpt,
         ben_benefit_actions ba
  where  ba.request_id=P_CONCURRENT_REQUEST_ID and
         ba.benefit_action_id=rpt.benefit_action_id and
         rpt.rep_typ_cd='LFBO';

Line: 118

  select count(rpt.person_id)
  into   CP_LF_EVT_BO
  from   ben_reporting rpt,
         ben_benefit_actions ba
  where  ba.request_id=P_CONCURRENT_REQUEST_ID and
         ba.benefit_action_id=rpt.benefit_action_id and
         rpt.rep_typ_cd='LFBO';

Line: 126

  select count(rpt.person_id)
  into   CP_LF_EVT_BO_CLS
  from   ben_reporting rpt,
         ben_benefit_actions ba
  where  ba.request_id=P_CONCURRENT_REQUEST_ID and
         ba.benefit_action_id=rpt.benefit_action_id and
         rpt.rep_typ_cd='LFBO' and
	 rpt.text like 'PROCD_';

Line: 135

  select count(rpt.person_id)
  into   CP_LF_EVT_BO_IP_WE
  from   ben_reporting rpt,
         ben_benefit_actions ba
  where  ba.request_id=P_CONCURRENT_REQUEST_ID and
         ba.benefit_action_id=rpt.benefit_action_id and
         rpt.rep_typ_cd='LFBO' and
         rpt.text = 'STRTDY';

Line: 144

  select count(rpt.person_id)
  into   CP_LF_EVT_BO_IP_WOE
  from   ben_reporting rpt,
         ben_benefit_actions ba
  where  ba.request_id=P_CONCURRENT_REQUEST_ID and
         ba.benefit_action_id=rpt.benefit_action_id and
         rpt.rep_typ_cd='LFBO' and
         rpt.text = 'STRTDN';

Line: 162

  l_persons_selected           varchar2(30);

Line: 175

     p_persons_selected           => L_PERSONS_SELECTED,
     p_persons_processed          => L_PERSONS_PROCESSED,
     p_persons_unprocessed        => L_PERSONS_UNPROCESSED,
     p_persons_processed_succ     => L_PERSONS_PROCESSED_SUCC,
     p_persons_errored            => L_PERSONS_ERRORED);

Line: 185

  CP_PERSONS_SELECTED           := l_persons_selected;

Line: 229

 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
	Begin
	 return CP_PERSON_SELECTION_RULE;

Line: 261

 Function CP_PERSONS_SELECTED_p return number is
	Begin
	 return CP_PERSONS_SELECTED;