APPS.PA_INSTALL dependencies on FND_APPLICATION

Line 70: from fnd_application a

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

Line 163: from fnd_application

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

Line 165: x_application_id fnd_application.application_id%TYPE;

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

Line 285: from fnd_application a

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