DBA Data[Home] [Help]

APPS.ETRM_SEARCH dependencies on FND_APPLICATION

Line 92: from APPLSYS.FND_APPLICATION_TL tl

88: cursor cur_apps
89: is
90: select app.application_id
91: , app.application_short_name || ' - '|| tl.application_name product_name
92: from APPLSYS.FND_APPLICATION_TL tl
93: , APPLSYS.FND_APPLICATION app
94: where app.application_id = tl.application_id
95: order by app.application_short_name;
96:

Line 93: , APPLSYS.FND_APPLICATION app

89: is
90: select app.application_id
91: , app.application_short_name || ' - '|| tl.application_name product_name
92: from APPLSYS.FND_APPLICATION_TL tl
93: , APPLSYS.FND_APPLICATION app
94: where app.application_id = tl.application_id
95: order by app.application_short_name;
96:
97: begin

Line 340: from APPLSYS.FND_APPLICATION_TL tl

336: cursor cur_app(c_search in varchar2)
337: is
338: select app.application_id
339: , tl.application_name product_name
340: from APPLSYS.FND_APPLICATION_TL tl
341: , APPLSYS.FND_APPLICATION app
342: where app.application_id = tl.application_id
343: and upper(c_search) = decode(app.application_short_name
344: , 'SQLAP', 'AP'

Line 341: , APPLSYS.FND_APPLICATION app

337: is
338: select app.application_id
339: , tl.application_name product_name
340: from APPLSYS.FND_APPLICATION_TL tl
341: , APPLSYS.FND_APPLICATION app
342: where app.application_id = tl.application_id
343: and upper(c_search) = decode(app.application_short_name
344: , 'SQLAP', 'AP'
345: , 'SQLGL', 'GL'