APPS.PAY_PAYWSDAS_PKG SQL Statements

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

Line: 22

select dbitl.user_name
,      dbitl.user_entity_id
from   ff_database_items_tl dbitl
where  dbitl.translated_user_name = p_operand_value
;

Line: 32

    select di.data_type
    ,      di.null_allowed_flag
    ,      ue.notfound_allowed_flag
    into   p_data_type
    ,      p_null_allowed
    ,      p_notfound_allowed
    from   ff_database_items di
    ,      ff_user_entities ue
    ,      ff_routes fr
    where  di.user_name = p_operand_value
    and    ue.user_entity_id = di.user_entity_id
    and    (
             (ue.business_group_id is null and ue.legislation_code is null) or
             ue.legislation_code = p_legislation_code or
             ue.business_group_id = p_business_group_id
           )
    and    fr.route_id = ue.route_id
    and    not exists
           (
             select  context_id
             from    ff_route_context_usages rcu
             where   rcu.route_id = fr.route_id
             minus
             select  context_id
             from    ff_ftype_context_usages fcu
             where   fcu.formula_type_id = p_formula_type_id
           )
    ;

Line: 75

            select di.data_type
            ,      di.null_allowed_flag
            ,      ue.notfound_allowed_flag
            into   p_data_type
            ,      p_null_allowed
            ,      p_notfound_allowed
            from   ff_database_items di
            ,      ff_user_entities ue
            ,      ff_routes fr
            where  di.user_name = dbitl.user_name
            and    di.user_entity_id = dbitl.user_entity_id
            and    ue.user_entity_id = dbitl.user_entity_id
            and    (
                     (ue.business_group_id is null and ue.legislation_code is null) or
                     ue.legislation_code = p_legislation_code or
                     ue.business_group_id = p_business_group_id
                   )
            and    fr.route_id = ue.route_id
            and    not exists
                   (
                     select  context_id
                     from    ff_route_context_usages rcu
                     where   rcu.route_id = fr.route_id
                     minus
                     select  context_id
                     from    ff_ftype_context_usages fcu
                     where   fcu.formula_type_id = p_formula_type_id
                   )
            ;

Line: 134

    select FORMULA_TYPE_ID
    from   FF_FORMULA_TYPES
    where  upper(FORMULA_TYPE_NAME) = 'ASSIGNMENT SET';

Line: 161

    select HR_ASSIGNMENT_SETS_S.nextval
    from   DUAL;

Line: 186

    select FORMULA_ID
    from   HR_ASSIGNMENT_SETS
    where  ASSIGNMENT_SET_ID = p_assignment_set_id;

Line: 213

    select null
    from   HR_ASSIGNMENT_SET_CRITERIA
    where  ASSIGNMENT_SET_ID = p_assignment_set_id;

Line: 238

    select null
    from   HR_ASSIGNMENT_SET_AMENDMENTS
    where  ASSIGNMENT_SET_ID = p_assignment_set_id;

Line: 264

    select null
    from   HR_ASSIGNMENT_SET_AMENDMENTS
    where  ASSIGNMENT_SET_ID = p_assignment_set_id
    and    ASSIGNMENT_ID     = p_assignment_id
    and (  p_rowid is null
        or p_rowid is not null and p_rowid <> ROWID);

Line: 291

    select null
    from   HR_ASSIGNMENT_SET_AMENDMENTS HR1,
           HR_ASSIGNMENT_SET_AMENDMENTS HR2
    where  HR1.ASSIGNMENT_SET_ID   = p_assignment_set_id
    and    HR1.ASSIGNMENT_SET_ID   = HR2.ASSIGNMENT_SET_ID
    and    HR1.INCLUDE_OR_EXCLUDE <> HR2.INCLUDE_OR_EXCLUDE;

Line: 320

    select null
    from   HR_ASSIGNMENT_SET_AMENDMENTS
    where  ASSIGNMENT_SET_ID   = p_assignment_set_id
    and    INCLUDE_OR_EXCLUDE <> p_include_exclude
    and  ( p_rowid is null
        or p_rowid is not null and p_rowid <> ROWID);

Line: 347

    select null
    from   HR_ASSIGNMENT_SET_CRITERIA
    where  ASSIGNMENT_SET_ID = p_assignment_set_id
    and    LINE_NO          <> p_line_no;

Line: 418

      select null
      from   HR_ASSIGNMENT_SETS
      where  upper(ASSIGNMENT_SET_NAME) = upper(p_assignment_set_name)
      and    business_group_id + 0          = p_business_group_id
      and    ( p_rowid is null
              or
              ( p_rowid is not null and ROWID <> p_rowid));

Line: 454

     select 'x'
     from   HR_ASSIGNMENT_SET_CRITERIA
     where  ASSIGNMENT_SET_ID = p_assignment_set_id
     and    LINE_NO           = p_line_no
     and   (p_rowid is null
            or p_rowid is not null and p_rowid <> ROWID);

Line: 478

procedure delete_formula(p_formula_id      in number,
                         p_formula_type_id in number) is
 --
  begin
  --
    delete
    from   FF_FORMULAS_F
    where  FORMULA_ID      = p_formula_id
    and    FORMULA_TYPE_ID = p_formula_type_id;

Line: 495

     select  ((FLOOR(max(LINE_NO) / 10)) + 1) * 10,
             min(LINE_NO)
     from    HR_ASSIGNMENT_SET_CRITERIA
     where   ASSIGNMENT_SET_ID = p_assignment_set_id;

Line: 535

  select bg.business_group_id
  ,      bg.legislation_code
  into   l_business_group_id
  ,      l_legislation_code
  from   hr_assignment_sets a_s
  ,      per_business_groups_perf bg
  where  a_s.assignment_set_id = p_assignment_set_id
  and    bg.business_group_id = a_s.business_group_id
  ;