APPS.PAY_CA_WAT_UDFS SQL Statements

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

Line: 10

SELECT peef.element_entry_id,
       decode(peef.entry_information1
             ,'P1',1000
             ,'P2',2000
             ,'P3',3000,9000) garn_priority
FROM pay_element_entries_f peef
    ,pay_element_classifications pec
    ,pay_element_types_f petf
    ,pay_element_links_f pelf
WHERE  peef.assignment_id = p_assignment_id
AND    trunc(p_earned_date) between trunc(peef.effective_start_date)
and
          trunc(peef.effective_end_date)
AND    peef.element_link_id = pelf.element_link_id
AND    trunc(p_earned_date) between trunc(pelf.effective_start_date)
and
          trunc(pelf.effective_end_date)
AND    pelf.element_type_id = petf.element_type_id
AND    trunc(p_earned_date) between trunc(petf.effective_start_date)
and
          trunc(petf.effective_end_date)
AND    petf.classification_id = pec.classification_id
AND    pec.classification_name like 'Involuntary Deductions'
ORDER BY decode(peef.entry_information1
               ,'P1',1000
               ,'P2',2000
               ,'P3',3000,9000),
         decode(peef.entry_information3
               ,'ORDER',1
               ,'EQUAL',2
               ,'PROPORTION',2,9),
         peef.entry_information4;