DBA Data[Home] [Help]

APPS.OKC_LSS_PVT dependencies on JTF_OBJECTS_B

Line 540: CURSOR jtot_pk_csr (p_jtot_object_code JTF_OBJECTS_B.object_code%type) IS

536: p_lssv_rec IN lssv_rec_type) IS
537: item_not_found_error EXCEPTION;
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)

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;