DBA Data[Home] [Help]

APPS.ASF_REC_VIEW_HIS_PUB dependencies on JTF_OBJECTS_B

Line 29: from JTF_OBJECTS_B

25: and OBJECT_ID = p_object_id
26: and LAST_UPDATED_BY = g_user_id;
27: else
28: select count(1) into l_exist
29: from JTF_OBJECTS_B
30: where OBJECT_CODE = p_object_code
31: and nvl(START_DATE_ACTIVE, l_date) <= l_date
32: and nvl(END_DATE_ACTIVE, l_date) >= l_date;
33: if (l_exist > 0) then