APPS.PAY_AIF_BUS SQL Statements

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

Line: 34

    select pbg.security_group_id
    from   per_business_groups       pbg
    ,      pay_action_information    aif
    ,      pay_assignment_actions    act
    ,      pay_payroll_actions       pct
    where  aif.action_information_id = p_action_information_id
    and    pbg.business_group_id     = pct.business_group_id
    and    act.payroll_action_id     = pct.payroll_action_id
    and    act.assignment_action_id  = aif.action_context_id
    and    aif.action_context_type   in ('AAP', 'AAC')
    union all
    select pbg.security_group_id
    from   per_business_groups       pbg
    ,      pay_action_information    aif
    ,      pay_payroll_actions       pct
    where  aif.action_information_id = p_action_information_id
    and    pbg.business_group_id     = pct.business_group_id
    and    pct.payroll_action_id     = aif.action_context_id
    and    aif.action_context_type   = 'PA';

Line: 108

    select pbg.legislation_code
    from   per_business_groups       pbg
    ,      pay_action_information    aif
    ,      pay_assignment_actions    act
    ,      pay_payroll_actions       pct
    where  aif.action_information_id = p_action_information_id
    and    pbg.business_group_id     = pct.business_group_id
    and    act.payroll_action_id     = pct.payroll_action_id
    and    act.assignment_action_id  = aif.action_context_id
    and    aif.action_context_type   in ('AAP', 'AAC')
    union all
    select pbg.legislation_code
    from   per_business_groups       pbg
    ,      pay_action_information    aif
    ,      pay_payroll_actions       pct
    where  aif.action_information_id = p_action_information_id
    and    pbg.business_group_id     = pct.business_group_id
    and    pct.payroll_action_id     = aif.action_context_id
    and    aif.action_context_type   = 'PA';

Line: 196

    select pbg.legislation_code
    from   per_business_groups       pbg
    ,      pay_assignment_actions    act
    ,      pay_payroll_actions       pct
    where  act.assignment_action_id  = p_action_context_id
    and    act.payroll_action_id     = pct.payroll_action_id
    and    pct.business_group_id     = pbg.business_group_id;

Line: 205

    select pbg.legislation_code
    from   per_business_groups     pbg
    ,      pay_payroll_actions     pct
    where  pct.payroll_action_id   = p_action_context_id
    and    pct.business_group_id   = pbg.business_group_id;

Line: 567

    select 'X'
    from   pay_payroll_actions
    where  payroll_action_id = p_action_context_id;

Line: 572

    select 'X'
    from   pay_assignment_actions
    where  assignment_action_id = p_action_context_id;

Line: 646

    select 'X'
    from   per_all_assignments_f
    where  assignment_id = p_assignment_id;

Line: 701

Procedure chk_non_updateable_args
  (p_rec in pay_aif_shd.g_rec_type
  ) IS
--
  l_proc     varchar2(72) := g_package || 'chk_non_updateable_args';

Line: 831

End chk_non_updateable_args;

Line: 836

Procedure insert_validate
  (p_rec                          in pay_aif_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 860

End insert_validate;

Line: 865

Procedure update_validate
  (p_rec                          in pay_aif_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 875

  chk_non_updateable_args(p_rec);

Line: 883

End update_validate;

Line: 888

Procedure delete_validate
  (p_rec                          in pay_aif_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 900

End delete_validate;