APPS.HR_EXTERNAL_APPLICATION dependencies on DUAL

Line 679: select fnd_web_config.database_id into l_dbc from dual;

675: End If;
676: Close C_Sel2;
677:
678: --Get dbc file
679: select fnd_web_config.database_id into l_dbc from dual;
680:
681: --First get the value from HR_EXT_AGENT
682: select fnd_profile.value('HR_KPI_AGENT') into l_hr_ext_servlet
683: from dual;

Line 683: from dual;

679: select fnd_web_config.database_id into l_dbc from dual;
680:
681: --First get the value from HR_EXT_AGENT
682: select fnd_profile.value('HR_KPI_AGENT') into l_hr_ext_servlet
683: from dual;
684: select fnd_profile.value('HR_KPI_GENFWK_SERVLET') into l_servlet
685: from dual;
686:
687: If l_hr_ext_servlet is null then

Line 685: from dual;

681: --First get the value from HR_EXT_AGENT
682: select fnd_profile.value('HR_KPI_AGENT') into l_hr_ext_servlet
683: from dual;
684: select fnd_profile.value('HR_KPI_GENFWK_SERVLET') into l_servlet
685: from dual;
686:
687: If l_hr_ext_servlet is null then
688: select fnd_profile.value('APPS_SERVLET_AGENT') into
689: l_apps_servlet_agent from dual;

Line 689: l_apps_servlet_agent from dual;

685: from dual;
686:
687: If l_hr_ext_servlet is null then
688: select fnd_profile.value('APPS_SERVLET_AGENT') into
689: l_apps_servlet_agent from dual;
690: l_hr_ext_servlet :=l_apps_servlet_agent;
691: end if;
692:
693: --Add custom seesion id and icx session_id

Line 935: FROM dual;

931: SELECT
932: hr_ki_ext_applications_s.nextval,
933: p_app_code,
934: l_app_id
935: FROM dual;
936:
937:
938: ELSE
939: -- otherwise update existing