APPS.PAY_CA_BEE SQL Statements

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

Line: 51

   SELECT 'Y'
   FROM   pay_element_entries_f pee
   WHERE  pee.element_link_id = p_element_link_id
   AND    pee.assignment_id = p_assignment_id
   AND    p_effective_date between pee.effective_start_date
                               and pee.effective_end_date;

Line: 73

   select *
   into g_line_record
   from pay_batch_lines
   where batch_line_id = l_batch_line_id;

Line: 78

   select *
   into g_header_record
   from pay_batch_headers
   where batch_id = g_line_record.batch_id;

Line: 96

       select elt.element_name
       into l_element_name
       from   pay_element_types_f elt
       where  elt.element_type_id = g_line_record.element_type_id
       and    (elt.business_group_id +0 = g_header_record.business_group_id
               or (elt.business_group_id is null
                   and elt.legislation_code = 'CA'))
       and    g_line_record.effective_date between elt.effective_start_date
                               and     elt.effective_end_date;

Line: 126

         select element_type_id
         into l_base_element_type_id
         from pay_element_types_f pet
         where  pet.element_name = l_base_element_name
         and    pet.processing_type = 'R'
         and    (pet.business_group_id = g_header_record.business_group_id
                or (pet.business_group_id IS NULL
                   and pet.legislation_code = 'CA'))
         and    g_line_record.effective_date between pet.effective_start_date
                                                 and pet.effective_end_date;