APPS.PAY_CA_BALANCE_VIEW_PKG SQL Statements

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

Line: 899

         select context_id
         into l_ctxid
         from ff_contexts
         where  context_name = p_context_name;

Line: 939

               select decode(hoi_bg.org_information9,
                       'US', hoi_gre.org_information5,
                       'CA', hoi_gre.org_information4)
               into   l_tax_group
               from
                      hr_organization_information hoi_bg,   -- Business Group
                      hr_organization_information hoi_gre,  -- US or CA Context
                      hr_all_organization_units hou         -- GRE
               where  hou.organization_id = to_number(p_context_value)
               and    hoi_gre.organization_id = hou.organization_id
               and    hoi_bg.organization_id = hou.business_group_id
               and    hoi_gre.org_information_context =
                         decode(hoi_bg.org_information9,
                                'US', 'Federal Tax Rules',
                                'CA', 'Canada Employer Identification',
                                'Not Applicable')
               and hoi_bg.org_information_context =  'Business Group Information';

Line: 1190

    SELECT 1
    FROM   ff_contexts cxt
    WHERE  context_name = 'SOURCE_ID';

Line: 1219

      select parameter_value
      into l_run_route
      from PAY_ACTION_PARAMETERS
      where parameter_name = 'RUN_ROUTE';

Line: 1246

      select pbd.legislation_code
      into   l_leg_code
      from   pay_defined_balances pdb,
             pay_balance_dimensions pbd
      where  pdb.defined_balance_id = p_defined_balance_id
      and    pbd.balance_dimension_id = pdb.balance_dimension_id;

Line: 1273

      select pdb.balance_type_id,
             pbd.database_item_suffix,
             pbd.dimension_type,
             pbd.dimension_name,
             pbt.jurisdiction_level,
             pbd.legislation_code
      into   l_balance_type_id,
             l_dbi_suffix,
             l_dimension_type,
             l_dimension_name,
             l_jurisdiction_level,
             l_leg_code
      from   pay_defined_balances pdb,
             pay_balance_dimensions pbd,
             pay_balance_types pbt
      where  pdb.defined_balance_id = p_defined_balance_id
      and    pbd.balance_dimension_id = pdb.balance_dimension_id
      and    pbt.balance_type_id = pdb.balance_type_id;

Line: 1308

    debug_msg( 'get_value: DBCache details updated for _defined_balance_id:  '
                                                                                                                                        || p_defined_balance_id);

Line: 1324

    select paa.assignment_id, paa.action_sequence, ppa.effective_date
    into   l_assignment_id, l_action_sequence, l_assact_effdate
    from   pay_assignment_actions paa,
           pay_payroll_actions ppa
    where  paa.assignment_action_id = p_assignment_action_id
    and    paa.payroll_action_id = ppa.payroll_action_id;

Line: 1496

/*    select distinct person_id
    into   l_person_id
    from   per_assignments_f
    where  assignment_id = l_assignment_id;

Line: 1648

  select to_number(substr(max(lpad(paa.action_sequence,15,'0')||
                   paa.assignment_action_id),16))
  from pay_assignment_actions paa,
       pay_payroll_actions    ppa
  where paa.assignment_id = p_assignment_id
  and   ppa.payroll_action_id = paa.payroll_action_id
  and   ppa.effective_date <= p_effective_date
  and   ppa.action_type in ('R', 'Q', 'I', 'V', 'B' );

Line: 1699

   select TP.end_date + 1
   into   l_return_val
   from   per_time_periods TP,
          pay_payroll_actions PACT,
          pay_assignment_actions ASSACT
   where  ASSACT.assignment_action_id = p_assactid
   and    PACT.payroll_action_id = ASSACT.payroll_action_id
   and    PACT.payroll_id = TP.payroll_id
   and    p_date between TP.start_date and TP.end_date;

Line: 1893

    SELECT fnd_date.canonical_to_date(org_information11)
    INTO   l_beg_of_fiscal_year
    FROM   pay_payroll_actions PACT,
           pay_assignment_actions ASSACT,
           hr_organization_information HOI
    WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
    AND    HOI.organization_id = PACT.business_group_id
    AND    PACT.payroll_action_id = ASSACT.payroll_action_id
    AND    ASSACT.assignment_action_id = p_owner_assignment_action_id;

Line: 1907

    SELECT fnd_date.canonical_to_date(org_information11)
    INTO   l_beg_of_fiscal_year
    FROM   pay_payroll_actions PACT,
           pay_assignment_actions ASSACT,
           hr_organization_information HOI
    WHERE  UPPER(HOI.org_information_context) = 'BUSINESS GROUP INFORMATION'
    AND    HOI.organization_id = PACT.business_group_id
    AND    PACT.payroll_action_id = ASSACT.payroll_action_id
    AND    ASSACT.assignment_action_id = p_owner_assignment_action_id;

Line: 1960

  select to_char ( sysdate, 'J HH24:MI:SS' )
    into v_now
    from dual;