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 1934: add_body_line(' from fnd_oracle_userid fou');

1930: add_body_line(' l_schema_name varchar2(100);');
1931: add_body_line(' cursor c_schema(c_app_short_name varchar2) is');
1932: add_body_line(' select fou.oracle_username');
1933: add_body_line(' into l_schema_name');
1934: add_body_line(' from fnd_oracle_userid fou');
1935: add_body_line(' ,fnd_product_installations fpi');
1936: add_body_line(' ,fnd_application fap');
1937: add_body_line(' where fou.oracle_id = fpi.oracle_id');
1938: add_body_line(' and fpi.application_id = fap.application_id');