APPS.HR_MULTI_TENANT_INSTALLER dependencies on FND_PRODUCT_INSTALLATIONS

Line 55: ,fnd_product_installations fpi

51: --
52: SELECT fou.oracle_username
53: INTO l_schema_name
54: FROM fnd_oracle_userid fou
55: ,fnd_product_installations fpi
56: ,fnd_application fap
57: WHERE fou.oracle_id = fpi.oracle_id
58: AND fpi.application_id = fap.application_id
59: AND fap.application_short_name = p_app_short_name;

Line 2147: add_body_line(' ,fnd_product_installations fpi');

2143: add_body_line(' cursor c_schema(c_app_short_name varchar2) is');
2144: add_body_line(' select fou.oracle_username');
2145: add_body_line(' into l_schema_name');
2146: add_body_line(' from fnd_oracle_userid fou');
2147: add_body_line(' ,fnd_product_installations fpi');
2148: add_body_line(' ,fnd_application fap');
2149: add_body_line(' where fou.oracle_id = fpi.oracle_id');
2150: add_body_line(' and fpi.application_id = fap.application_id');
2151: add_body_line(' and fap.application_short_name = c_app_short_name;');