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:
32: --UPDATE--
33: CURSOR c_update(b_lastrundate DATE) IS

Line 37: FROM JTF_OBJECT_MAPPINGS B

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

Line 45: FROM JTF_OBJECT_MAPPINGS B

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