APPS.AD_VERSION_UTIL dependencies on FND_APPLICATION

Line 30: -- FND_APPLICATION table

26: --
27: -- Return product abbreviation given a product shortname
28: --
29: -- Raises an exception if the product shortname is not found in
30: -- FND_APPLICATION table
31: --
32:
33: function get_appl_abbr
34: (p_appl_shortname in varchar2)

Line 47: from fnd_application

43:
44: begin
45: select null
46: into l_dummy
47: from fnd_application
48: where application_short_name = upper(p_appl_shortname);
49: exception
50: when NO_DATA_FOUND then
51: raise_application_error(-20001,

Line 73: from fnd_application

69: l_appl_id number;
70: begin
71: select application_id
72: into l_appl_id
73: from fnd_application
74: where application_short_name = upper(p_appl_sn);
75:
76: return(l_appl_id);
77: end;

Line 443: from fnd_application

439: update fnd_product_installations
440: set patch_level = l_new_patch_level
441: where application_id in (
442: select application_id
443: from fnd_application
444: where application_short_name = upper(p_appl_shortname));
445: end if;
446: end;
447: