APPS.ETRM_FNDNAV dependencies on FND_APPLICATION

Line 21: from APPLSYS.FND_APPLICATION_TL tl

17: select decode(app.application_short_name, 'SQLAP', 'AP'
18: , 'SQLGL', 'GL'
19: , app.application_short_name)
20: || ' - '|| tl.application_name product_name
21: from APPLSYS.FND_APPLICATION_TL tl
22: , APPLSYS.FND_APPLICATION app
23: where app.application_id = tl.application_id
24: and app.application_id = n_appid
25: and tl.language = userenv('LANG');

Line 22: , APPLSYS.FND_APPLICATION app

18: , 'SQLGL', 'GL'
19: , app.application_short_name)
20: || ' - '|| tl.application_name product_name
21: from APPLSYS.FND_APPLICATION_TL tl
22: , APPLSYS.FND_APPLICATION app
23: where app.application_id = tl.application_id
24: and app.application_id = n_appid
25: and tl.language = userenv('LANG');
26:

Line 163: from FND_APPLICATION_TL tl

159: , decode(app.application_short_name, 'SQLAP', 'AP'
160: , 'SQLGL', 'GL'
161: , app.application_short_name)
162: || ' - '|| tl.application_name product_name
163: from FND_APPLICATION_TL tl
164: , FND_APPLICATION app
165: where app.application_id = tl.application_id
166: and tl.language = userenv('LANG')
167: order by decode(app.application_short_name, 'SQLAP', 'AP'

Line 164: , FND_APPLICATION app

160: , 'SQLGL', 'GL'
161: , app.application_short_name)
162: || ' - '|| tl.application_name product_name
163: from FND_APPLICATION_TL tl
164: , FND_APPLICATION app
165: where app.application_id = tl.application_id
166: and tl.language = userenv('LANG')
167: order by decode(app.application_short_name, 'SQLAP', 'AP'
168: , 'SQLGL', 'GL'

Line 280: , fnd_application a

276: cursor cur_event(c_name in dba_objects.object_name%type := '%'
277: , n_appid in number) is
278: select count(e.name) id_count
279: from wf_events e
280: , fnd_application a
281: where a.application_id = n_appid
282: and e.owner_tag = a.application_short_name
283: and e.name like c_name ESCAPE '\';
284:

Line 423: from fnd_application

419: , c_type in dba_objects.object_type%type := '%') is
420:
421: cursor cur_apps is
422: select application_id
423: from fnd_application
424: order by decode(application_short_name, 'SQLAP', 'AP'
425: , 'SQLGL', 'GL'
426: , application_short_name);
427:

Line 530: , fnd_application a

526: , n_appid in number) is
527: select e.name
528: , e.guid id
529: from wf_events e
530: , fnd_application a
531: where a.application_id = n_appid
532: and e.owner_tag = a.application_short_name
533: and e.name like c_name ESCAPE '\';
534:

Line 1708: from APPLSYS.FND_APPLICATION_TL tl

1704: , decode(app.application_short_name, 'SQLAP', 'AP'
1705: , 'SQLGL', 'GL'
1706: , app.application_short_name)
1707: || ' - '|| tl.application_name product_name
1708: from APPLSYS.FND_APPLICATION_TL tl
1709: , APPLSYS.FND_APPLICATION app
1710: where app.application_id = tl.application_id
1711: and tl.language = userenv('LANG')
1712: order by decode(app.application_short_name, 'SQLAP', 'AP'

Line 1709: , APPLSYS.FND_APPLICATION app

1705: , 'SQLGL', 'GL'
1706: , app.application_short_name)
1707: || ' - '|| tl.application_name product_name
1708: from APPLSYS.FND_APPLICATION_TL tl
1709: , APPLSYS.FND_APPLICATION app
1710: where app.application_id = tl.application_id
1711: and tl.language = userenv('LANG')
1712: order by decode(app.application_short_name, 'SQLAP', 'AP'
1713: , 'SQLGL', 'GL'

Line 1860: , fnd_application app

1856: select decode(app.application_short_name, 'SQLAP', 'AP'
1857: , 'SQLGL', 'GL'
1858: , app.application_short_name) application_short_name
1859: from fnd_tables t
1860: , fnd_application app
1861: where table_name = c_name
1862: and t.application_id = app.application_id;
1863:
1864:

Line 1871: , fnd_application app

1867: select decode(app.application_short_name, 'SQLAP', 'AP'
1868: , 'SQLGL', 'GL'
1869: , app.application_short_name) application_short_name
1870: from fnd_views t
1871: , fnd_application app
1872: where view_name = c_name
1873: and t.application_id = app.application_id;
1874:
1875: