3 Replies Latest reply: Feb 14, 2013 10:45 AM by 892288 RSS

    What is order number under the Approver Group in AME

    user-Keen
      Brother,

      I have requirment to send FYI notification to the supervisour if any request occure throug self service. But i am stuck what should i pass in the field of "Order number", however, i have written the query which are.

      select 'person_id:'||a.supervisor_id
      from per_all_assignments_f a,
      hr_api_transactions hat
      where a.person_id = hat.selected_person_id
      and hat.transaction_id = :transactionId
      and trunc(sysdate) between a.effective_start_date and a.effective_end_date