APPS.HR_KI_WF_MISC SQL Statements

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

Line: 23

  SELECT hr_ki_be_s.nextval INTO l_event_key FROM dual;

Line: 124

     select etd.confirmation
       into l_enabled
       from ecx_tp_headers_v eth
            ,ecx_tp_details_v etd
       where eth.tp_header_id=etd.tp_header_id
         and eth.party_id = l_party_id
         and eth.party_site_id =l_party_site_id
         and etd.transaction_type=l_trans_type
         and etd.transaction_subtype=l_trans_subtype;