DBA Data[Home] [Help]

APPS.FND_OBJECT_TABLESPACES_PKG dependencies on FND_ORACLE_USERID

Line 137: from fnd_oracle_userid fou,

133: where application_id = p_application_id
134: and object_name = p_object_name;
135: CURSOR c1 IS
136: select fou.oracle_username
137: from fnd_oracle_userid fou,
138: fnd_product_installations fpi
139: where fou.oracle_id = fpi.oracle_id
140: and fpi.application_id = p_application_id;
141: l_schema FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;

Line 141: l_schema FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;

137: from fnd_oracle_userid fou,
138: fnd_product_installations fpi
139: where fou.oracle_id = fpi.oracle_id
140: and fpi.application_id = p_application_id;
141: l_schema FND_ORACLE_USERID.ORACLE_USERNAME%TYPE;
142: BEGIN
143: if p_oracle_username IS NULL then
144: OPEN c1;
145: FETCH c1 INTO l_schema;