APPS.HR_AUBAL SQL Statements

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

Line: 55

    select  assignment_id
    from    pay_assignment_actions          paa
    ,       pay_payroll_actions             ppa
    where   paa.assignment_action_id        = c_assignment_action_id
            and       ppa.payroll_action_id = paa.payroll_action_id
            and       ppa.action_type       in ('R', 'Q', 'I', 'V', 'B');

Line: 90

    select  pdb.defined_balance_id
    from    pay_defined_balances          pdb
    ,       pay_balance_dimensions        pbd
    where   pdb.balance_dimension_id      = pbd.balance_dimension_id
            and pbd.database_item_suffix  = c_db_item_suffix
            and pdb.balance_type_id       = c_balance_type_id;

Line: 130

    select  to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
    from    pay_assignment_actions      paa
    ,       per_assignments_f           paf
    ,       pay_payroll_actions         ppa
    where   paa.assignment_id           = c_assignment_id
            and paf.assignment_id       = c_assignment_id
            and paf.assignment_id       = paa.assignment_id
            and ppa.payroll_action_id   = paa.payroll_action_id
            and ppa.effective_date      <= c_effective_date
            and ppa.action_type         in ('R', 'Q', 'I', 'V', 'B')
            and paa.action_status='C'
            and ppa.payroll_id          = paf.payroll_id
            and ppa.effective_date      between paf.effective_start_date and paf.effective_end_date
            and ppa.action_status='C' ; /*Bug - 3019374 */

Line: 170

    select  ppa.effective_date
    from    pay_payroll_actions           ppa
    ,       pay_assignment_actions        paa
    where   paa.payroll_action_id         = ppa.payroll_action_id
            and paa.assignment_action_id  = p_assignment_action_id;

Line: 1110

  select business_group_id
  from   per_assignments_f
  where  assignment_id = p_assignment_id;

Line: 1255

  select business_group_id
  from   per_assignments_f
  where  assignment_id = p_assignment_id;

Line: 1408

    select  ptp.end_date
    from    per_time_periods            ptp
    ,       pay_payroll_actions         ppa
    ,       pay_assignment_actions      paa
    where   paa.assignment_action_id    = c_assignment_action_id
            and paa.payroll_action_id   = ppa.payroll_action_id
            and ppa.time_period_id      = ptp.time_period_id;

Line: 1672

  select    ptp.end_date
  from      per_time_periods            ptp
  ,         pay_payroll_actions         ppa
  ,         pay_assignment_actions      paa
  where     paa.assignment_action_id    = c_assignment_action_id
  and       paa.payroll_action_id       = ppa.payroll_action_id
  and       ppa.time_period_id          = ptp.time_period_id;

Line: 1807

    select  ptp.end_date
    from    per_time_periods            ptp
    ,       pay_payroll_actions         ppa
    ,       pay_assignment_actions      paa
    where   paa.assignment_action_id    = c_assignment_action_id
            and   paa.payroll_action_id = ppa.payroll_action_id
            and   ppa.time_period_id    = ptp.time_period_id;