DBA Data[Home] [Help]

APPS.HR_XML_UTIL SQL Statements

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

Line: 260

    select transaction_document
    from hr_api_transactions
    where transaction_id = p_transaction_id;
Line: 395

    select transaction_id
    from hr_api_transactions
    where ITEM_KEY = p_item_key
    and ITEM_TYPE  = p_item_type;
Line: 423

   select pk1,pk2,pk3,pk4,pk5
   from hr_api_transaction_steps
   where transaction_id=p_transaction_id
   and  OBJECT_TYPE = p_object_type
   and  OBJECT_NAME = p_object_name;