APPS.PAY_QPE_API SQL Statements

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

Line: 52

    select 'Y'
      from pay_assignment_actions
     where assignment_action_id = p_assignment_action_id;

Line: 57

    select 'Y'
      from pay_payroll_actions     pya
         , pay_assignment_actions  asa
     where pya.action_type          = 'Q'
       and pya.payroll_action_id    = asa.payroll_action_id
       and asa.assignment_action_id = p_assignment_action_id;

Line: 147

    select 'Y'
      from dual
     where exists (select 'Y'
                     from pay_element_entries_f
                    where element_entry_id = p_rec.element_entry_id);

Line: 154

    select pya.date_earned
      from
           pay_element_types_f    et
         , pay_element_links_f    el
         , pay_element_entries_f  ent
         , pay_payroll_actions    pya
         , pay_assignment_actions aga
     where ent.element_entry_id     = p_rec.element_entry_id
       and ent.effective_start_date <= pya.date_earned
       and ent.effective_end_date   >= decode(et.proration_group_id, null, pya.date_earned,
                                              pay_interpreter_pkg.prorate_start_date
                                                     (aga.assignment_action_id,
                                                      et.proration_group_id
                                                     ))
       and ent.element_link_id = el.element_link_id
       and el.element_type_id = et.element_type_id
       and pya.date_earned between el.effective_start_date
                               and el.effective_end_date
       and pya.date_earned between et.effective_start_date
                               and et.effective_end_date
       and pya.payroll_action_id    = aga.payroll_action_id
       and aga.assignment_action_id = p_rec.assignment_action_id;

Line: 178

    select 'Y'
      from
           pay_element_types_f    et
         , pay_element_links_f    el
         , pay_element_entries_f  ent
         , pay_payroll_actions    pya
         , pay_assignment_actions aga
     where ent.element_entry_id     = p_rec.element_entry_id
       and ent.assignment_id        = aga.assignment_id
       and ent.effective_start_date <= pya.date_earned
       and ent.effective_end_date   >= decode(et.proration_group_id, null, pya.date_earned,
                                              pay_interpreter_pkg.prorate_start_date
                                                     (aga.assignment_action_id,
                                                      et.proration_group_id
                                                     ))
       and ent.element_link_id = el.element_link_id
       and el.element_type_id = et.element_type_id
       and pya.date_earned between el.effective_start_date
                               and el.effective_end_date
       and pya.date_earned between et.effective_start_date
                               and et.effective_end_date
       and pya.payroll_action_id    = aga.payroll_action_id
       and aga.assignment_action_id = p_rec.assignment_action_id;

Line: 206

    select 'Y'
    from pay_assignment_actions asgt_act,
         pay_run_results rr
    where asgt_act.assignment_action_id = rr.assignment_action_id
    and rr.source_id = p_element_entry_id
    and rr.source_type in ('E','I')
    and (asgt_act.assignment_action_id = p_assignment_action_id
         or asgt_act.source_action_id = p_assignment_action_id);

Line: 323

    select 'Y'
      from pay_quickpay_exclusions
     where element_entry_id     = p_rec.element_entry_id
       and assignment_action_id = p_rec.assignment_action_id;

Line: 384

    select 'Y'
      from pay_assignment_actions
     where assignment_action_id = p_assignment_action_id
       and action_status        in  ('C', 'S');

Line: 392

    select 'Y'
      from pay_payroll_actions    pya
         , pay_assignment_actions aga
     where aga.assignment_action_id = p_assignment_action_id
       and pya.payroll_action_id    = aga.payroll_action_id
       and pya.current_task         is not null;

Line: 468

procedure insert_dml(p_rec in out nocopy pay_quickpay_exclusions%ROWTYPE) is
--
  v_proc  varchar2(72) := g_package||'insert_dml';

Line: 477

  insert into pay_quickpay_exclusions
    (element_entry_id
    ,assignment_action_id
    ,created_by
    ,creation_date
    ,last_update_date
    ,last_updated_by
    ,last_update_login
    )
  values
    (p_rec.element_entry_id
    ,p_rec.assignment_action_id
    ,fnd_global.user_id
    ,sysdate
    ,sysdate
    ,fnd_global.user_id
    ,fnd_global.login_id
    );

Line: 497

end insert_dml;

Line: 530

Procedure delete_dml(p_rec in pay_quickpay_exclusions%ROWTYPE) is
--
  v_proc varchar2(72) := g_package||'delete_dml';

Line: 539

  delete from pay_quickpay_exclusions
   where element_entry_id     = p_rec.element_entry_id
     and assignment_action_id = p_rec.assignment_action_id;

Line: 555

End delete_dml;

Line: 569

    select *
      from pay_quickpay_exclusions
     where element_entry_id     = p_element_entry_id
       and assignment_action_id = p_assignment_action_id
       for update nowait;

Line: 695

procedure insert_validate(p_rec in pay_quickpay_exclusions%ROWTYPE) is
--
  v_proc varchar2(72) := g_package||'insert_validate';

Line: 727

end insert_validate;

Line: 756

procedure delete_validate(p_rec in pay_quickpay_exclusions%ROWTYPE) is
--
  v_proc  varchar2(72) := g_package||'delete_validate';

Line: 769

end delete_validate;

Line: 797

  insert_validate(p_rec);

Line: 801

  insert_dml(p_rec);

Line: 896

    delete_validate(p_rec);

Line: 900

    delete_dml(p_rec);