APPS.PA_INSTALL dependencies on FND_APPLICATION

Line 71: from fnd_application a

67: select p.status
68: into x_status
69: from fnd_product_installations p
70: where p.application_id = (select a.application_id
71: from fnd_application a
72: where a.application_short_name = 'PJI'
73: )
74: ;
75:

Line 164: from fnd_application

160: RETURN BOOLEAN
161: is
162: cursor get_application_id is
163: select application_id
164: from fnd_application
165: where application_short_name = p_product_short_name;
166: x_application_id fnd_application.application_id%TYPE;
167:
168: Cursor get_installation_status is

Line 166: x_application_id fnd_application.application_id%TYPE;

162: cursor get_application_id is
163: select application_id
164: from fnd_application
165: where application_short_name = p_product_short_name;
166: x_application_id fnd_application.application_id%TYPE;
167:
168: Cursor get_installation_status is
169: select nvl(status,'N') from fnd_product_installations
170: where application_id = x_application_id;

Line 286: from fnd_application a

282: select p.status
283: into x_status
284: from fnd_product_installations p
285: where p.application_id = (select a.application_id
286: from fnd_application a
287: where a.application_short_name = 'ONT'
288: ) ;
289:
290: if (x_status = 'N' OR x_status is null) then