APPS.OKC_LSS_PVT dependencies on JTF_OBJECT_USAGES

Line 542: FROM JTF_OBJECTS_B a,jtf_object_usages b

538: l_row_notfound BOOLEAN := TRUE;
539: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
540: CURSOR jtot_pk_csr (p_jtot_object_code JTF_OBJECTS_B.object_code%type) IS
541: SELECT '1'
542: FROM JTF_OBJECTS_B a,jtf_object_usages b
543: WHERE a.object_code = p_jtot_object_code
544: and sysdate between nvl(a.start_date_active,sysdate) and nvl(a.end_date_active,sysdate)
545: and a.object_code=b.object_code and b.object_user_code='OKX_LINES';
546: l_jtot_pk jtot_pk_csr%ROWTYPE;

Line 589: from JTF_OBJECT_USAGES where

585: l_object_user_code VARCHAR2(30):=NULL;
586: l_mtl_found BOOLEAN := FALSE;
587: CURSOR loc_source_csr is
588: select OBJECT_USER_CODE
589: from JTF_OBJECT_USAGES where
590: OBJECT_CODE = p_lssv_rec.JTOT_OBJECT_CODE
591: AND OBJECT_USER_CODE = 'OKX_MTL_SYSTEM_ITEM';
592:
593: BEGIN