APPS.PAY_GBE_BUS SQL Statements

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

Line: 187

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

Line: 227

End chk_non_updateable_args;

Line: 274

    Select 'Y'
    From   pay_grossup_bal_exclusions
    Where  not
           ((start_date < p_start_date
             and nvl(end_date, hr_general.END_OF_TIME) < p_start_date)
             OR
            (start_date > p_end_date
             AND NVL(end_date, hr_general.END_OF_TIME) > NVL(p_end_date, hr_general.END_OF_TIME))
           )
    And    not (grossup_balances_id = p_grossup_balances_id)
    And    source_type = p_source_type
    And    source_id   = p_source_id
    And    balance_type_id = p_balance_type_id ;

Line: 373

    Select 'Y'
    From   pay_grossup_bal_exclusions
    Where  not
           ((start_date < p_start_date
             and nvl(end_date, hr_general.END_OF_TIME) < p_start_date)
             OR
            (start_date > p_end_date
             AND NVL(end_date, hr_general.END_OF_TIME) > NVL(p_end_date, hr_general.END_OF_TIME))
           )
    And    source_type = p_source_type
    And    source_id   = p_source_id
    And    balance_type_id = p_balance_type_id ;

Line: 454

          Select distinct ee.element_entry_id
          from pay_element_entries_f ee
          where ee.element_entry_id = p_source_id ;

Line: 459

          Select distinct et.element_type_id
          from pay_element_types_f et
          where et.element_type_id = p_source_id ;

Line: 541

          select balance_type_id
          from   pay_balance_types
          where  balance_type_id = p_balance_type_id ;

Line: 603

    select 'Y'
    from  pay_grossup_bal_exclusions gbe
    where gbe.balance_type_id = p_balance_type_id
    and   gbe.start_date      = p_start_date
    and   gbe.end_date        = p_end_date
    and   gbe.source_type     = p_source_type
    and   gbe.source_id       = p_source_id ;

Line: 632

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

Line: 664

End insert_validate;

Line: 669

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

Line: 680

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 705

End update_validate;

Line: 710

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

Line: 722

End delete_validate;