DBA Data[Home] [Help]

APPS.EDW_BSC_BRIDGE dependencies on USER_OBJECTS

Line 130: user_objects

126: )IS
127: SELECT
128: object_name
129: FROM
130: user_objects
131: WHERE
132: object_name = UPPER(p_fact_name)
133: AND object_type = 'TABLE';
134:

Line 141: user_objects

137: )IS
138: SELECT
139: object_name
140: FROM
141: user_objects
142: WHERE
143: object_name = UPPER(p_fact_name)
144: AND object_type = 'SYNONYM';
145:

Line 615: l_object USER_OBJECTS.OBJECT_NAME%TYPE := NULL;

611:
612: FUNCTION CHECK_FACT_VALIDILITY(
613: p_fact_name IN EDW_FACT_ATTRIBUTES_MD_V.FACT_NAME%TYPE
614: ) RETURN VARCHAR2 IS
615: l_object USER_OBJECTS.OBJECT_NAME%TYPE := NULL;
616: BEGIN
617: OPEN c_factvalidity_t(p_fact_name);
618: FETCH c_factvalidity_t INTO l_object;
619: CLOSE c_factvalidity_t;