APPS.PA_INSTALL dependencies on FND_PRODUCT_INSTALLATIONS

Line 68: from fnd_product_installations p

64: BEGIN
65:
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: )

Line 137: l_status fnd_product_installations.status%type;

133:
134: FUNCTION is_costing_licensed RETURN VARCHAR2
135: IS
136: x_pa_costing_installed VARCHAR2(2);
137: l_status fnd_product_installations.status%type;
138: BEGIN
139:
140: select status
141: into l_status

Line 142: from fnd_product_installations

138: BEGIN
139:
140: select status
141: into l_status
142: from fnd_product_installations
143: where application_id = 275;
144:
145: if ( l_status = 'I') then
146: x_pa_costing_installed := 'Y';

Line 168: select nvl(status,'N') from fnd_product_installations

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;
170:
171: x_status fnd_product_installations.status%TYPE;
172:

Line 171: x_status fnd_product_installations.status%TYPE;

167: Cursor get_installation_status is
168: select nvl(status,'N') from fnd_product_installations
169: where application_id = x_application_id;
170:
171: x_status fnd_product_installations.status%TYPE;
172:
173: Begin
174: IF p_product_short_name = 'IPA' then
175: if CRL_INSTALLED IS NULL then

Line 283: from fnd_product_installations p

279: BEGIN
280:
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: ) ;