APPS.PAY_PGL_PKG SQL Statements

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

Line: 8

   select cost_allocation_structure
   from    per_business_groups
   where   business_group_id + 0  = p_business_group_id;

Line: 28

  select name
  ,      chart_of_accounts_id
  from   gl_sets_of_books
  where  set_of_books_id = p_gl_set_of_books_id;

Line: 33

  select display_period_type
  from   per_time_period_types_vl
  where  period_type = p_period_type;

Line: 70

   select segment_name
   from fnd_id_flex_segments
   where id_flex_code = l_flex_code
   and    id_flex_num  = l_flex_num
   and    enabled_flag = 'Y'
   and    application_column_name = l_column_name;

Line: 96

select ''
from   pay_payroll_gl_flex_maps
where  payroll_id = p_payroll_id
and    gl_set_of_books_id = p_gl_set_of_books_id
and    gl_account_segment = p_gl_account_segment
and   ( p_rowid is null or
      (p_rowid is not null
   and chartorowid(p_rowid) <> rowid));

Line: 120

  select ''
  from   pay_payrolls_f
  where  payroll_id = p_payroll_id
  and    effective_start_date > p_session_date;