APPS.HR_EXTERNAL_APPLICATION SQL Statements

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

Line: 290

  SELECT external_application_id
  FROM   hr_ki_ext_applications
  WHERE  external_application_name = p_app_code;

Line: 634

select topic_id  from hr_ki_topics where
topic_key=p_topic;

Line: 638

select integration_id from hr_ki_integrations where
 integration_key =p_provider ;

Line: 679

select fnd_web_config.database_id into l_dbc from dual;

Line: 682

select fnd_profile.value('HR_KPI_AGENT') into l_hr_ext_servlet
from dual;

Line: 684

select fnd_profile.value('HR_KPI_GENFWK_SERVLET') into l_servlet
from dual;

Line: 688

select fnd_profile.value('APPS_SERVLET_AGENT') into
l_apps_servlet_agent from dual;

Line: 695

select SESSION_ID into l_session_id from icx_sessions where
icx_sessions.login_id = to_number(fnd_profile.value('LOGIN_ID'));

Line: 823

  SELECT external_application_id
  FROM   hr_ki_ext_applications
  WHERE  external_application_name = p_app_code;

Line: 922

  DELETE FROM hr_ki_ext_applications
  WHERE external_application_name = p_app_code;

Line: 925

  INSERT INTO hr_ki_ext_applications
    (
    ext_application_id,
    external_application_name,
    external_application_id
    )
  SELECT
    hr_ki_ext_applications_s.nextval,
    p_app_code,
    l_app_id
  FROM dual;

Line: 970

  UPDATE hr_ki_ext_applications
    SET external_application_id = l_app_id
    WHERE external_application_name = p_app_code;