APPS.IA_WF_UTIL_PKG SQL Statements

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

Line: 463

        SELECT  application_id
        INTO    l_application_id
        FROM    fnd_application
        WHERE   application_short_name = IA_WF_UTIL_PKG.ApplicationShortName;

Line: 782

  select nvl(rd.enable_transfer_flag,'N')
        ,nvl(rd.allow_transaction_date_flag,'N')
        ,nvl(rd.responsibility_type,IA_WF_UTIL_PKG.RespTypeRequest)
        ,nvl(rd.require_superuser_flag,'N')
        ,nvl(rd.approval_type,IA_WF_UTIL_PKG.ApprovalTypeAll)
        ,nvl(rd.approval_method,IA_WF_UTIL_PKG.ApprovalMethodCostCenter)
  into TransferEnabled
      ,TransactionDateAllowed
      ,ResponsibilityType
      ,SuperUserApprovalRequired
      ,ApprovalType
      ,ApprovalMethod
  from ia_rule_details rd
  where rd.rule_id=p_rule_id
    and rd.book_type_code=p_book_type_code;

Line: 821

  select flv.meaning
  into l_meaning
  from fnd_lookup_values flv
  where flv.lookup_type=p_lookup_type
    and flv.lookup_code=p_lookup_code
    and flv.view_application_id=205 -- IA application id
    and flv.language=nvl(userenv('LANG'),'US')
    and flv.security_group_id =
           fnd_global.lookup_security_group
           (flv.lookup_type
           ,flv.view_application_id
           );