DBA Data[Home] [Help]

APPS.AP_AWT_CALLOUT_PKG SQL Statements

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

Line: 18

   SELECT UNIQUE call_app_pay_service_req_code, payment_id
   FROM IBY_HOOK_PAYMENTS_T
   WHERE CALLING_APP_ID = 200;
Line: 23

   SELECT UNIQUE CALLING_APP_DOC_UNIQUE_REF1
   FROM IBY_HOOK_DOCS_IN_PMT_T
   WHERE PAYMENT_ID = l_payment_id
   AND CALLING_APP_ID=200;
Line: 44

               P_Calling_Module =>     'AUTOSELECT',
               P_Amount      =>        NULL,
               P_Payment_Num   =>      NULL,
               P_Checkrun_Name =>      l_pay_service_req_code,
               P_Checkrun_id  =>       l_checkrun_id,
               P_Last_Updated_By =>      fnd_global.user_id,
               P_Last_Update_Login =>    FND_GLOBAL.LOGIN_ID,
               P_Program_Application_Id =>  fnd_global.prog_appl_id,
               P_Program_Id      =>      fnd_global.conc_program_id,
               P_Request_Id      =>      fnd_global.conc_request_id ,
               P_Invoice_Payment_Id  =>    NULL,
               P_Check_Id            =>   NULL);