APPS.PA_INSTALL dependencies on FND_PRODUCT_INSTALLATIONS

Line 69: from fnd_product_installations p

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

Line 138: l_status fnd_product_installations.status%type;

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

Line 143: from fnd_product_installations

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

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

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

Line 172: x_status fnd_product_installations.status%TYPE;

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

Line 284: from fnd_product_installations p

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