APPS.HR_MULTI_TENANT_INSTALLER dependencies on FND_ORACLE_USERID

Line 54: FROM fnd_oracle_userid fou

50: -- short name passed as parameter.
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

Line 91: FROM fnd_oracle_userid fou

87: --
88:
89: SELECT fou.oracle_username
90: INTO l_schema_name
91: FROM fnd_oracle_userid fou
92: WHERE fou.oracle_id = p_oracle_id;
93: RETURN l_schema_name;
94:
95: END get_schema_by_oracleid;

Line 2146: add_body_line(' from fnd_oracle_userid fou');

2142: add_body_line(' l_schema_name varchar2(100);');
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');