DBA Data[Home] [Help]

APPS.HR_MULTI_TENANT_INSTALLER dependencies on FND_APPLICATION

Line 56: ,fnd_application fap

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;
60: RETURN l_schema_name;

Line 1936: add_body_line(' ,fnd_application fap');

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');
1939: add_body_line(' and fap.application_short_name = c_app_short_name;');
1940: add_body_line(' begin');