APPS.PAY_ASSG_COST_WF SQL Statements

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

Line: 176

      /*Update the status of the previous approver to true as the control
      comes to this place once the approver approves it.*/

      hr_utility.set_location(l_proc,20);

Line: 180

      ame_api2.updateApprovalStatus2(
                  applicationIdIn             =>801,
                  transactionTypeIn           =>'PAY_ASSIGNMENT_COSTING',
                  transactionIdIn             =>l_transaction_id,
                  approvalStatusIn            => ame_util.approvedStatus,
                  approverNameIn              => wf_engine.getItemAttrText(itemtype, itemkey,'APPROVER_LOGIN_NAME'),
                  updateItemIn                => true);

Line: 255

      select FULL_NAME
      from per_all_people_f
      where person_id = p_person_id
      and trunc(sysdate) between effective_start_date and effective_end_date;

Line: 384

    hr_utility.set_location('Transaction deleted successfully ',20);