APPS.PER_IN_ENTRY_VALUE_LEG_HOOK SQL Statements

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

Line: 228

    SELECT pet.element_information1
      FROM pay_element_types_f pet
     WHERE pet.element_type_id = p_element_type_id_o
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;

Line: 236

    SELECT pee.element_entry_id
      FROM pay_element_types_f pet
          ,pay_element_entries_f pee
     WHERE pet.element_type_id =pee.element_type_id
       AND pee.assignment_id = p_assignment_id_o
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date
       AND p_effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date
       AND pet.element_information1 = p_element_name;

Line: 246

    SELECT pet.element_name
      FROM pay_element_types_f pet
     WHERE pet.element_type_id = p_element_type_id_o
       AND p_effective_date BETWEEN pet.effective_start_date AND pet.effective_end_date;

Line: 253

   SELECT 1
     FROM per_assignment_extra_info pae
    WHERE assignment_id =  p_assignment_id_o
      AND ( (pae.aei_information_category = 'PER_IN_MEDICAL_BILLS' AND pae.aei_information10 = p_element_entry_id)
         OR (pae.aei_information_category = 'PER_IN_MEDICAL_BILLS' AND pae.aei_information11 = p_element_entry_id)
         OR (pae.aei_information_category = 'PER_IN_LTC_BILLS' AND pae.aei_information11 = p_element_entry_id));