APPS.PAY_CA_BALANCE_PKG SQL Statements

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

Line: 142

  SELECT pai.locked_action_id
  FROM   pay_payroll_actions    ppa,
         pay_assignment_actions paa,
         pay_action_interlocks  pai
  WHERE  pai.locking_action_id = p_prepay_aa_id
  AND    paa.assignment_action_id = pai.locked_action_id
  AND    ppa.payroll_action_id = paa.payroll_action_id
  AND    ppa.action_type IN ('R', 'Q')
  and    not exists ( select 1 from pay_run_types_f prt
                       where   prt.legislation_code = 'CA'
                         and   prt.run_method = 'S'
                         and   prt.run_type_id  = paa.run_type_id );

Line: 156

  SELECT pai.locking_action_id
  FROM   pay_payroll_actions    ppa,
         pay_assignment_actions paa,
         pay_action_interlocks  pai
  WHERE  pai.locked_action_id = p_run_id
  AND    paa.assignment_action_id = pai.locking_action_id
  AND    ppa.payroll_action_id = paa.payroll_action_id
  AND    ppa.action_type IN ('P', 'U');

Line: 166

  SELECT 1
  FROM   pay_assignment_actions    paa
     ,   pay_run_types_f prt
  WHERE  paa.assignment_action_id = p_run_aa_id
    and  prt.legislation_code = 'CA'
    and  prt.run_method = 'S'
    and  prt.run_type_id  = paa.run_type_id;

Line: 263

     select max(paa.assignment_action_id)
     from   pay_assignment_actions paa,  -- assignment_action for master payroll run
            pay_action_interlocks pai
     where  pai.locking_action_id = cp_prepay_action_id
     and    pai.locked_action_id = paa.assignment_action_id
     and    paa.assignment_id    = cp_assignment_id
     and    paa.source_action_id is null -- master assignment_action
     group by assignment_id;

Line: 365

        select pac.context_value
          into l_tax_group
          from pay_action_contexts pac
              ,ff_contexts fc
         where pac.assignment_action_id = p_assignment_action_id
         and   fc.context_name = 'TAX_GROUP'
         and   pac.context_id  = fc.context_id;

Line: 450

        SELECT DECODE(prt.shortname,'SEP_PAY','Y','N'),
               paa.assignment_id
        INTO   l_sep_check,
               l_assignment_id
        FROM   pay_assignment_actions paa
              ,pay_run_types_f        prt
        WHERE  paa.assignment_action_id = p_assignment_action_id
        AND    prt.run_type_id          = paa.run_type_id
        AND    prt.legislation_code     = 'CA';

Line: 469

            select paa_master.source_action_id
            into   l_assignment_action_id
            from   pay_assignment_actions paa_master
                  ,pay_assignment_actions paa_sm
            where  paa_sm.assignment_action_id = p_assignment_action_id
            and    paa_master.assignment_action_id = paa_sm.source_action_id;

Line: 476

            select paa.source_action_id
            into   l_assignment_action_id
            from   pay_assignment_actions paa
            where  paa.assignment_action_id = p_assignment_action_id;

Line: 559

SELECT pai.locking_action_id, count(pai2.locked_action_id)
FROM   pay_action_interlocks pai,
       pay_action_interlocks pai2,
       pay_assignment_actions paa,
       pay_payroll_actions    ppa
WHERE  pai.locked_action_id = p_asgact_id
AND    pai.locking_action_id = pai2.locking_action_id
AND    pai.locking_action_id = paa.assignment_action_id
AND    paa.payroll_action_id = ppa.payroll_action_id
AND    ppa.action_type in ('P', 'U')
GROUP BY pai.locking_action_id;