APPS.FND_OAM_COLLECTION dependencies on FND_PROFILE_OPTIONS

Line 362: from fnd_profile_options po,

358: -- web server url to construct the url to ping for servlet agent.
359: begin
360: select pov.profile_option_value
361: into v_url
362: from fnd_profile_options po,
363: fnd_profile_option_values pov
364: where po.profile_option_name = 'APPS_SERVLET_AGENT'
365: and pov.application_id = po.application_id
366: and pov.profile_option_id = po.profile_option_id

Line 416: from fnd_profile_options po,

412: v_server varchar(100);
413: begin
414: select pov.profile_option_value
415: into v_launcher
416: from fnd_profile_options po,
417: fnd_profile_option_values pov
418: where po.profile_option_name = 'ICX_REPORT_LAUNCHER'
419: and pov.application_id = po.application_id
420: and pov.profile_option_id = po.profile_option_id

Line 425: from fnd_profile_options po,

421: and pov.level_id = 10001;
422:
423: select pov.profile_option_value
424: into v_server
425: from fnd_profile_options po,
426: fnd_profile_option_values pov
427: where po.profile_option_name = 'ICX_REPORT_SERVER'
428: and pov.application_id = po.application_id
429: and pov.profile_option_id = po.profile_option_id

Line 450: from fnd_profile_options po,

446: v_launcher varchar(1000);
447: begin
448: select pov.profile_option_value
449: into v_launcher
450: from fnd_profile_options po,
451: fnd_profile_option_values pov
452: where po.profile_option_name = 'ICX_FORMS_LAUNCHER'
453: and pov.application_id = po.application_id
454: and pov.profile_option_id = po.profile_option_id

Line 1561: from fnd_profile_options ovl,

1557:
1558: if (is_collection_enabled('PROFILE_OPT')) then
1559: -- get the number of profile options changed in last 24 hours
1560: select count(*) into ct_profile_options
1561: from fnd_profile_options ovl,
1562: fnd_profile_option_values v
1563: where ovl.start_date_active <= SYSDATE
1564: and (nvl(ovl.end_date_active, SYSDATE) >= SYSDATE)
1565: and (v.level_id = 10001 and v.level_value = 0)