eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_BF_BALANCE_AMOUNTS_API SQL Statements

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

Line: 15


  SELECT input_value_id, currency, uom
   FROM  per_bf_balance_types
   WHERE balance_type_id = p_balance_type_id;

Line: 21


  SELECT et.input_currency_code
       , iv.uom
  FROM pay_element_types_f et
     , pay_input_values_f iv
  WHERE iv.input_value_id = p_input_value_id
    AND iv.element_type_id = et.element_type_id
    AND p_effective_date BETWEEN
        iv.effective_start_date AND iv.effective_end_date
    AND p_effective_date BETWEEN
        et.effective_start_date AND et.effective_end_date;

Line: 133


  SELECT processed_assignment_id, object_version_number
    FROM per_bf_processed_assignments
   WHERE payroll_run_id = p_payroll_run_id
     AND assignment_id = p_assignment_id;

Line: 432


procedure update_balance_amount
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_ytd_amount                    in     number   default hr_api.g_number
  ,p_fytd_amount                   in     number   default hr_api.g_number
  ,p_ptd_amount                    in     number   default hr_api.g_number
  ,p_mtd_amount                    in     number   default hr_api.g_number
  ,p_qtd_amount                    in     number   default hr_api.g_number
  ,p_run_amount                    in     number   default hr_api.g_number
  ,p_currency_code                 in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute_category        in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute1                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute2                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute3                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute4                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute5                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute6                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute7                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute8                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute9                in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute10               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute11               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute12               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute13               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute14               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute15               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute16               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute17               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute18               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute19               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute20               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute21               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute22               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute23               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute24               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute25               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute26               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute27               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute28               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute29               in     varchar2 default hr_api.g_varchar2
  ,p_bba_attribute30               in     varchar2 default hr_api.g_varchar2
  ,p_balance_amount_id             in     number
  ,p_balance_amount_ovn            in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  -- Cursor to get the balance_type_id
  CURSOR csr_get_bbt IS
  SELECT balance_type_id
    FROM per_bf_balance_amounts
   WHERE balance_amount_id = p_balance_amount_id;

Line: 490


  l_proc                varchar2(72) := g_package||'update_balance_amount';

Line: 496


  savepoint update_balance_amount;

Line: 506


    PER_BF_BALANCE_AMOUNTS_BK2.UPDATE_BALANCE_AMOUNT_B
      (p_effective_date                => p_effective_date
      ,p_ytd_amount                    => p_ytd_amount
      ,p_fytd_amount                   => p_fytd_amount
      ,p_ptd_amount                    => p_ptd_amount
      ,p_mtd_amount                    => p_mtd_amount
      ,p_qtd_amount                    => p_qtd_amount
      ,p_run_amount                    => p_run_amount
      ,p_currency_code                 => p_currency_code
      ,p_bba_attribute_category           => p_bba_attribute_category
      ,p_bba_attribute1                   => p_bba_attribute1
      ,p_bba_attribute2                   => p_bba_attribute2
      ,p_bba_attribute3                   => p_bba_attribute3
      ,p_bba_attribute4                   => p_bba_attribute4
      ,p_bba_attribute5                   => p_bba_attribute5
      ,p_bba_attribute6                   => p_bba_attribute6
      ,p_bba_attribute7                   => p_bba_attribute7
      ,p_bba_attribute8                   => p_bba_attribute8
      ,p_bba_attribute9                   => p_bba_attribute9
      ,p_bba_attribute10                  => p_bba_attribute10
      ,p_bba_attribute11                  => p_bba_attribute11
      ,p_bba_attribute12                  => p_bba_attribute12
      ,p_bba_attribute13                  => p_bba_attribute13
      ,p_bba_attribute14                  => p_bba_attribute14
      ,p_bba_attribute15                  => p_bba_attribute15
      ,p_bba_attribute16                  => p_bba_attribute16
      ,p_bba_attribute17                  => p_bba_attribute17
      ,p_bba_attribute18                  => p_bba_attribute18
      ,p_bba_attribute19                  => p_bba_attribute19
      ,p_bba_attribute20                  => p_bba_attribute20
      ,p_bba_attribute21                  => p_bba_attribute21
      ,p_bba_attribute22                  => p_bba_attribute22
      ,p_bba_attribute23                  => p_bba_attribute23
      ,p_bba_attribute24                  => p_bba_attribute24
      ,p_bba_attribute25                  => p_bba_attribute25
      ,p_bba_attribute26                  => p_bba_attribute26
      ,p_bba_attribute27                  => p_bba_attribute27
      ,p_bba_attribute28                  => p_bba_attribute28
      ,p_bba_attribute29                  => p_bba_attribute29
      ,p_bba_attribute30                  => p_bba_attribute30
      ,p_balance_amount_id             => p_balance_amount_id
      ,p_balance_amount_ovn            => p_balance_amount_ovn
       );

Line: 553


        (p_module_name => 'UPDATE_BALANCE_AMOUNT'
        ,p_hook_type   => 'BP'
        );

Line: 628


    PER_BF_BALANCE_AMOUNTS_BK2.UPDATE_BALANCE_AMOUNT_A
      (p_effective_date                => p_effective_date
      ,p_ytd_amount                    => p_ytd_amount
      ,p_fytd_amount                   => p_fytd_amount
      ,p_ptd_amount                    => p_ptd_amount
      ,p_mtd_amount                    => p_mtd_amount
      ,p_qtd_amount                    => p_qtd_amount
      ,p_run_amount                    => p_run_amount
      ,p_currency_code                 => p_currency_code
      ,p_bba_attribute_category           => p_bba_attribute_category
      ,p_bba_attribute1                   => p_bba_attribute1
      ,p_bba_attribute2                   => p_bba_attribute2
      ,p_bba_attribute3                   => p_bba_attribute3
      ,p_bba_attribute4                   => p_bba_attribute4
      ,p_bba_attribute5                   => p_bba_attribute5
      ,p_bba_attribute6                   => p_bba_attribute6
      ,p_bba_attribute7                   => p_bba_attribute7
      ,p_bba_attribute8                   => p_bba_attribute8
      ,p_bba_attribute9                   => p_bba_attribute9
      ,p_bba_attribute10                  => p_bba_attribute10
      ,p_bba_attribute11                  => p_bba_attribute11
      ,p_bba_attribute12                  => p_bba_attribute12
      ,p_bba_attribute13                  => p_bba_attribute13
      ,p_bba_attribute14                  => p_bba_attribute14
      ,p_bba_attribute15                  => p_bba_attribute15
      ,p_bba_attribute16                  => p_bba_attribute16
      ,p_bba_attribute17                  => p_bba_attribute17
      ,p_bba_attribute18                  => p_bba_attribute18
      ,p_bba_attribute19                  => p_bba_attribute19
      ,p_bba_attribute20                  => p_bba_attribute20
      ,p_bba_attribute21                  => p_bba_attribute21
      ,p_bba_attribute22                  => p_bba_attribute22
      ,p_bba_attribute23                  => p_bba_attribute23
      ,p_bba_attribute24                  => p_bba_attribute24
      ,p_bba_attribute25                  => p_bba_attribute25
      ,p_bba_attribute26                  => p_bba_attribute26
      ,p_bba_attribute27                  => p_bba_attribute27
      ,p_bba_attribute28                  => p_bba_attribute28
      ,p_bba_attribute29                  => p_bba_attribute29
      ,p_bba_attribute30                  => p_bba_attribute30
      ,p_balance_amount_id             => p_balance_amount_id
      ,p_balance_amount_ovn            => l_balance_amount_ovn
      );

Line: 674


        (p_module_name => 'UPDATE_BALANCE_AMOUNT'
        ,p_hook_type   => 'AP'
        );

Line: 697


    rollback to update_balance_amount;

Line: 710


    rollback to update_balance_amount;

Line: 715


end UPDATE_BALANCE_AMOUNT;

Line: 721


procedure delete_balance_amount
  (p_validate                      in     boolean  default false
  ,p_balance_amount_id             in     number
  ,p_balance_amount_ovn            in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  --
  CURSOR csr_get_pa_id IS
  SELECT pa.processed_assignment_id, pa.object_version_number
    FROM PER_BF_BALANCE_AMOUNTS  ba
	,PER_BF_PROCESSED_ASSIGNMENTS pa
   WHERE ba.balance_amount_id = p_balance_amount_id
     AND ba.processed_assignment_id = pa.processed_assignment_id;

Line: 739


  SELECT 1
    FROM per_bf_balance_amounts
   WHERE processed_assignment_id = p_processed_assignment_id
     AND balance_amount_id <> p_balance_amount_id
   UNION
  SELECT 1
    FROM per_bf_payment_details
   WHERE processed_assignment_id = p_processed_assignment_id;

Line: 751


  l_delete_pa_row            BOOLEAN;

Line: 752


  l_proc                varchar2(72) := g_package||'delete_balance_amount';

Line: 758


  savepoint delete_balance_amount;

Line: 768


    PER_BF_BALANCE_AMOUNTS_BK3.DELETE_BALANCE_AMOUNT_B
      (
       p_balance_amount_id             => p_balance_amount_id
      ,p_balance_amount_ovn            => p_balance_amount_ovn
       );

Line: 777


        (p_module_name => 'DELETE_BALANCE_AMOUNT'
        ,p_hook_type   => 'BP'
        );

Line: 815


    l_delete_pa_row := TRUE;

Line: 821


    l_delete_pa_row := FALSE;

Line: 834


  IF l_delete_pa_row THEN
    --
    -- The processed_assignment row is to be removed, so
    -- remove it
    --
    per_bpa_del.del
      ( p_processed_assignment_id      => l_processed_assignment_id
      , p_object_version_number        => l_processed_assignment_ovn
      );

Line: 851


    PER_BF_BALANCE_AMOUNTS_BK3.DELETE_BALANCE_AMOUNT_A
      (
       p_balance_amount_id             => p_balance_amount_id
      ,p_balance_amount_ovn            => p_balance_amount_ovn
      );

Line: 859


        (p_module_name => 'DELETE_BALANCE_AMOUNT'
        ,p_hook_type   => 'AP'
        );

Line: 880


    rollback to delete_balance_amount;

Line: 891


    rollback to delete_balance_amount;

Line: 894


end DELETE_BALANCE_AMOUNT;