APPS.PQH_AME_APPROVALS SQL Statements

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

Line: 121

           ame_api.updateApprovalStatus2(
                 applicationIdIn    => l_txn_app_id,
                 transactionIdIn    => l_transaction_id,
                 transactionTypeIn  => l_txn_type,
                 approvalStatusIn   => ame_util.approvedStatus,
                 approverPersonIdIn => l_forward_from_person_id,
                 approverUserIdIn   => null,
                 forwardeeIn        => null);

Line: 177

     Select object_version_number
     into   l_ovn
     From   ben_elig_per_elctbl_chc
     Where  elig_per_elctbl_chc_id  = l_elctbl_chc_id;

Line: 183

     ben_elig_per_elc_chc_api.update_elig_per_elc_chc (
        p_elig_per_elctbl_chc_id  => l_elctbl_chc_id
       ,p_approval_status_cd      => p_app_rej
       ,p_object_version_number   => l_ovn
       ,p_effective_date          => sysdate);

Line: 277

     Select object_version_number
     into l_ovn
     From ben_elig_per_elctbl_chc
    Where elig_per_elctbl_chc_id  = l_elctbl_chc_id;

Line: 282

    ben_elig_per_elc_chc_api.update_elig_per_elc_chc (
        p_elig_per_elctbl_chc_id  => l_elctbl_chc_id
       ,p_in_pndg_wkflow_flag     => 'N'
       ,p_object_version_number   => l_ovn
       ,p_effective_date          => sysdate);