APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on JTF_OBJECT_MAPPINGS

Line 29: FROM JTF_OBJECT_MAPPINGS B

25: CURSOR c_delete IS
26: SELECT ACC.ACCESS_ID
27: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC
28: WHERE NOT EXISTS (SELECT 1
29: FROM JTF_OBJECT_MAPPINGS B
30: WHERE B.MAPPING_ID = ACC.MAPPING_ID
31: AND NVL(B.END_DATE,SYSDATE)>= SYSDATE);
32:
33: --UPDATE--

Line 38: FROM JTF_OBJECT_MAPPINGS B

34: CURSOR c_update(b_lastrundate DATE) IS
35: SELECT ACC.ACCESS_ID
36: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC
37: WHERE EXISTS (SELECT 1
38: FROM JTF_OBJECT_MAPPINGS B
39: WHERE B.MAPPING_ID = ACC.MAPPING_ID
40: AND B.LAST_UPDATE_DATE > b_lastrundate );
41:
42:

Line 46: FROM JTF_OBJECT_MAPPINGS B

42:
43: --INSERT--
44: CURSOR c_insert IS
45: SELECT MAPPING_ID
46: FROM JTF_OBJECT_MAPPINGS B
47: WHERE NVL(B.END_DATE,SYSDATE)>= SYSDATE
48: AND B.OBJECT_CODE = 'JTF_NOTE_TYPE'
49: AND NOT EXISTS (SELECT 1
50: FROM CSM_NOTES_TYPE_MAPPING_ACC ACC