APPS.BEN_BENPRSUM_XMLP_PKG SQL Statements

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

Line: 18

l_comp_object_selection_rule ff_formulas_f.formula_name%type ;

Line: 19

l_person_selection_rule      ff_formulas_f.formula_name%type ;

Line: 48

     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: 74

  CP_COMP_OBJECT_SELECTION_RULE := l_comp_object_selection_rule;

Line: 75

  CP_PERSON_SELECTION_RULE      := l_person_selection_rule;

Line: 93

    Select count(distinct rep.person_id) prcurmop
  into CP_PRCURMOP
      from ben_reporting rep
          ,ben_benefit_actions bft
     where bft.benefit_action_id = rep.benefit_action_id
       and bft.request_id = P_CONCURRENT_REQUEST_ID
       and rep.rep_typ_cd in ('PRCURMOP', 'PRPPOIPL')
       and not exists (select distinct rep.person_id
           from ben_reporting rep
               ,ben_benefit_actions bft
          where bft.benefit_action_id = rep.benefit_action_id
            and bft.request_id = P_CONCURRENT_REQUEST_ID
            and rep.rep_typ_cd in ('PRRETROP', 'PRCREDIT')) ;

Line: 107

    Select count(distinct rep.person_id) prcredit
  into CP_PRCREDIT
      from ben_reporting rep
          ,ben_benefit_actions bft
     where bft.benefit_action_id = rep.benefit_action_id
       and bft.request_id = P_CONCURRENT_REQUEST_ID
       and rep.rep_typ_cd = ('PRCREDIT')
       and not exists (select distinct rep.person_id
           from ben_reporting rep
               ,ben_benefit_actions bft
          where bft.benefit_action_id = rep.benefit_action_id
            and bft.request_id = P_CONCURRENT_REQUEST_ID
            and rep.rep_typ_cd in ('PRCURMOP', 'PRRETROP', 'PRPPOIPL')) ;

Line: 121

    Select count(distinct rep.person_id) prretrop
  into CP_PRRETROP
      from ben_reporting rep
          ,ben_benefit_actions bft
     where bft.benefit_action_id = rep.benefit_action_id
       and bft.request_id = P_CONCURRENT_REQUEST_ID
       and rep.rep_typ_cd = ('PRRETROP')
       and not exists (select distinct rep.person_id
           from ben_reporting rep
               ,ben_benefit_actions bft
          where bft.benefit_action_id = rep.benefit_action_id
            and bft.request_id = P_CONCURRENT_REQUEST_ID
            and rep.rep_typ_cd in ('PRCURMOP', 'PRCREDIT', 'PRPPOIPL')) ;

Line: 136

    Select count(distinct rep.person_id) prtotal
  into CP_PRTOTAL
      from ben_reporting rep
          ,ben_benefit_actions bft
     where bft.benefit_action_id = rep.benefit_action_id
       and bft.request_id = P_CONCURRENT_REQUEST_ID
       and rep.rep_typ_cd IN ('PRCREDIT', 'PRCURMOP', 'PRRETROP', 'PRPPOIPL') ;

Line: 156

  l_persons_selected           varchar2(30);

Line: 169

     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: 179

  CP_PERSONS_SELECTED           := l_persons_selected;

Line: 264

	 return CP_COMP_OBJECT_SELECTION_RULE;

Line: 266

 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
	Begin
	 return CP_PERSON_SELECTION_RULE;

Line: 326

 Function CP_PERSONS_SELECTED_p return number is
	Begin
	 return CP_PERSONS_SELECTED;