APPS.BEN_BENCMEPE_XMLP_PKG SQL Statements

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

Line: 13

  l_person_selection_rule      ff_formulas_f.formula_name%type ;

Line: 45

                  p_person_selection_rule   => l_person_selection_rule,
                  p_organization            => l_organization,
                  p_location                => l_location,
                  p_ler                     => l_life_event_reason,
                  p_program                 => l_program,
                  p_plan                    => l_plan,
                  p_plan_in_program         => l_plan_in_program,
                  p_actn_typ                => l_actn_typ,
                  p_elig_enrol              => l_elig_enrol,
                  p_age_fctr                => l_age_fctr,
                  p_min_age                 => l_min_age,
                  p_max_age                 => l_max_age,
                  p_los_fctr                => l_los_fctr,
                  p_min_los                 => l_min_los,
                  p_max_los                 => l_max_los,
                  p_cmbn_age_los_fctr       => l_cmbn_age_los_fctr,
                  p_date_from               => l_date_from,
                  p_enrollment_period       => l_enrollment_period,
                  p_audit_log               => l_audit_log,
                  p_status                  => l_status);

Line: 78

  CP_PERSON_SELECTION_RULE      := l_person_selection_rule;

Line: 102

  l_persons_selected           varchar2(30);

Line: 115

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

  CP_PERSONS_SELECTED           := l_persons_selected;

Line: 189

 Function CP_PERSON_SELECTION_RULE_p return varchar2 is
	Begin
	 return CP_PERSON_SELECTION_RULE;

Line: 229

 Function CP_PERSONS_SELECTED_p return number is
	Begin
	 return CP_PERSONS_SELECTED;