APPS.PAY_STANDARD_CHECK SQL Statements

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

Line: 6

       select 'X'
       from pay_input_values_f piv,
       hr_lookups hrl,
       pay_batch_lines pbl

       where l_meaning = piv.name             -- restrict to input value parameter
       and piv.name = hrl.meaning             -- join piv-hrl on name of input value

       and hrl.lookup_type = 'CONTROL_TYPE'   -- restrict to relevant lookup
       and hrl.lookup_code like '_TOTAL_COLUMN_%'    -- must be a standard total

       and pbl.element_type_id = piv.element_type_id -- join piv-pbl on element_type_id
       and pbl.batch_id = l_batch_id ;                -- restrict to batch_id parameter

Line: 71

       select distinct element_type_id, element_name
       from pay_batch_lines
       where batch_id=l_batch_id;

Line: 80

       select piv.name
       from pay_input_values_f piv
       where piv.element_type_id = l_element_type_id
       and sysdate between piv.effective_start_date and piv.effective_end_date
       order by piv.display_sequence, piv.name;

Line: 116

select hlk.meaning into l_meaning
from hr_lookups hlk
where   hlk.lookup_type = 'CONTROL_TYPE'
and     hlk.lookup_code = p_control_type;

Line: 130

    select count(*) into l_n_lines
    from   pay_batch_lines bal
    where  bal.batch_id = p_batch_id;

Line: 173

     select business_group_id
     into   l_business_group_id
     from   pay_batch_headers
     where  batch_id = p_batch_id;

Line: 195

                     l_sql_stat:='select sum(value_'||l_value_number||') from pay_batch_lines where element_type_id='||l_element.element_type_id||' and batch_id='||p_batch_id;

Line: 197

                     l_sql_stat:='select sum(fnd_number.canonical_to_number(value_'||l_value_number||')) from pay_batch_lines where element_type_id='||l_element.element_type_id||' and batch_id='||p_batch_id;