APPS.AZW_GROUP dependencies on FND_PRODUCT_INSTALLATIONS

Line 126: FROM fnd_product_installations fpi, fnd_application_vl fav

122: --- end of hard coding for CST
123:
124: SELECT count(*)
125: INTO v_count_installed
126: FROM fnd_product_installations fpi, fnd_application_vl fav
127: WHERE fpi.application_id = fav.application_id
128: AND fav.application_id = v_appl_id
129: AND fpi.status = 'I';
130: IF (v_count_installed = 0) THEN

Line 150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');

146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_group.get_installed_flag');
150: fnd_message.set_token('AZW_ERROR_STMT','select status from fnd_product_installations,fnd_application_vl');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END get_installed_flag;
153:
154:

Line 170: FROM az_groups azg, fnd_product_installations fpi

166: BEGIN
167:
168: SELECT count(*)
169: INTO v_count_installed
170: FROM az_groups azg, fnd_product_installations fpi
171: WHERE fpi.application_id = azg.application_id
172: AND fpi.status = 'I'
173: AND azg.dependency_parent_id = p_group_id
174: AND process_type = g_current_mode;