APPS.HR_API_WF_EVENTS SQL Statements

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

Line: 78

    select ahk.hook_procedure
         , ahk.api_hook_type
         , ahk.api_hook_id
         , ahk.legislation_package
         , ahk.legislation_function
         , amd.module_name
         , amd.data_within_business_group
      from hr_api_modules  amd
         , hr_api_hooks    ahk
     where amd.api_module_id = ahk.api_module_id
       and ahk.hook_package  = p_hook_package
       and amd.api_module_type='BP'
       and ahk.api_hook_type='AP';

Line: 196

    add_body_line('  select per_wf_events_s.nextval from dual;');

Line: 336

    select ahm.api_module_id
         , ahk.api_hook_id
         , ahk.hook_procedure
      from hr_api_hooks   ahk
         , hr_api_modules ahm
     where ahk.hook_package    = p_hook_package
       and ahk.api_module_id   = ahm.api_module_id
       and ahm.api_module_type='BP'
       and ahk.api_hook_type='AP';

Line: 387

    select ahk.hook_procedure
    from hr_api_hooks   ahk
    where ahk.hook_package    = p_hook_package
    and ahk.api_hook_type='AP';

Line: 393

    select GUID,STATUS
    from wf_events
    where name=p_event_name;

Line: 398

  select application_name
  from fnd_application_vl
  where application_short_name=p_application_short_name;

Line: 507

select distinct ah.hook_package
from hr_api_modules am
,    hr_api_hooks ah
where am.api_module_id=ah.api_module_id
and am.module_package=p_api_package
and am.api_module_type='BP'
and ah.api_hook_type='AP';

Line: 526

  select per_wf_events_s.nextval into p_event.Correlation_ID from dual;