APPS.OKS_COVERAGES_PVT dependencies on JTF_NOTES_VL

Line 692: FROM JTF_NOTES_VL

688: note_status_meaning,
689: decoded_source_code,
690: decoded_source_meaning,
691: context
692: FROM JTF_NOTES_VL
693: WHERE source_object_id = p_source_object_id
694: AND source_object_code = 'OKS_COVTMPL_NOTE'
695: AND note_status <> 'P';
696: -------------------------------------------------------------------------------

Line 2318: FROM JTF_NOTES_VL

2314: l_service_line_id NUMBER;
2315:
2316: CURSOR Cur_Get_notes(p_source_object_id IN Number) IS
2317: SELECT jtf_note_id
2318: FROM JTF_NOTES_VL
2319: WHERE source_object_id = p_source_object_id
2320: AND source_object_code = 'OKS_COV_NOTE';
2321: */
2322: -- End of Bug:4535339 by Jvorugan

Line 6683: FROM JTF_NOTES_VL B

6679: -- Modified by Jvorugan for Bug:4489214 who columns not to be populated from old contract
6680: B.Entered_by Entered_by,
6681: B.Entered_date Entered_date
6682: -- End of changes for Bug:4489214
6683: FROM JTF_NOTES_VL B
6684: WHERE B.SOURCE_OBJECT_ID = l_id
6685: AND B.SOURCE_OBJECT_CODE = P_source_object_code ; -- Bug:5944200
6686:
6687:

Line 10138: FROM JTF_NOTES_VL

10134: note_status_meaning,
10135: decoded_source_code,
10136: decoded_source_meaning,
10137: context
10138: FROM JTF_NOTES_VL
10139: WHERE source_object_id = p_source_object_id
10140: AND source_object_code = p_source_object_code -- 'OKS_COVTMPL_NOTE'
10141: AND note_status <> (case when p_source_object_code ='OKS_COVTMPL_NOTE' THEN 'P' ELSE '!' END);
10142: -- Commented by Jvorugan. note_status <> 'P';