DBA Data[Home] [Help]

APPS.CS_KB_SET_LINKS_PKG dependencies on JTF_OBJECTS_VL

Line 125: FROM jtf_objects_vl v, jtf_object_usages u

121: SELECT 'SELECT count(*) FROM '||
122: v.From_Table||
123: ' WHERE '||v.select_id||' = :1 '||
124: decode( v.where_clause, null, ' ', ' AND ' || v.where_clause )
125: FROM jtf_objects_vl v, jtf_object_usages u
126: WHERE v.object_code = P_OBJECT_CODE
127: AND v.object_code = u.object_code
128: AND u.object_user_code='CS_KB_SET'
129: and ( v.end_date_active is NULL or v.end_date_active > sysdate );