APPS.BEN_BENFRAUD_XMLP_PKG SQL Statements

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

Line: 18

  l_comp_object_selection_rule varchar2(80);

Line: 19

  l_person_selection_rule      varchar2(80);

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

  select bft.process_date,
           hr2.meaning,
           nvl(pln.name,l_all),
           conc.user_concurrent_program_name,
           fnd1.meaning
  into   CP_PROCESS_DATE, CP_VALIDATE, CP_PLAN, CP_CONCURRENT_PROGRAM_NAME, CP_STATUS
    from   ben_benefit_actions bft,
           hr_lookups hr2,
           ben_pl_f pln,
           fnd_lookups fnd1,
           fnd_concurrent_requests fnd,
           fnd_concurrent_programs_tl conc
    where  fnd.request_id = P_CONCURRENT_REQUEST_ID
    and    conc.concurrent_program_id = fnd.concurrent_program_id
    and    conc.application_id = 805
    and    bft.request_id = fnd.request_id
    and    hr2.lookup_code = bft.validate_flag
    and    hr2.lookup_type = 'YES_NO'
    and    fnd.status_code = fnd1.lookup_code
    and    fnd1.lookup_type = 'CP_STATUS_CODE'
    and    pln.pl_id(+) = bft.pl_id
    and    bft.process_date
           between nvl(pln.effective_start_date,bft.process_date)
           and     nvl(pln.effective_end_date,bft.process_date);

Line: 134

  l_persons_selected           varchar2(30);

Line: 147

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

  CP_PERSONS_SELECTED           := l_persons_selected;

Line: 234

 Function CP_COMP_OBJECT_SELECTION_RULE1 return varchar2 is
	Begin
	 return CP_COMP_OBJECT_SELECTION_RULE;

Line: 238

 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
	Begin
	 return CP_PERSON_SELECTION_RULE;

Line: 298

 Function CP_PERSONS_SELECTED_p return number is
	Begin
	 return CP_PERSONS_SELECTED;