APPS.CSM_RESCODE_MAPPING_EVENT_PKG dependencies on CSM_RESCODE_MAPPING_ACC

Line 36: SELECT csm_rescode_mapping_acc_s.nextval,

32: --Cursor Declarations
33: --Insert Cursor
34: CURSOR csr_rescode_map_ins
35: IS
36: SELECT csm_rescode_mapping_acc_s.nextval,
37: b.resolution_map_detail_id
38: FROM CS_SR_RES_CODE_MAPPING_DETAIL b
39: WHERE NOT EXISTS
40: (

Line 42: FROM CSM_RESCODE_MAPPING_ACC acc

38: FROM CS_SR_RES_CODE_MAPPING_DETAIL b
39: WHERE NOT EXISTS
40: (
41: SELECT 1
42: FROM CSM_RESCODE_MAPPING_ACC acc
43: WHERE acc.resolution_map_detail_id = b.resolution_map_detail_id
44: );
45: --update cursor
46: CURSOR csr_rescode_map_upd(p_lastrundate IN date)

Line 49: FROM CSM_RESCODE_MAPPING_ACC acc,

45: --update cursor
46: CURSOR csr_rescode_map_upd(p_lastrundate IN date)
47: IS
48: SELECT access_id
49: FROM CSM_RESCODE_MAPPING_ACC acc,
50: CS_SR_RES_CODE_MAPPING_DETAIL b
51: WHERE b.resolution_map_detail_id = acc.resolution_map_detail_id
52: AND b.last_update_Date >= p_lastrundate;
53: --Delete cursor

Line 57: FROM CSM_RESCODE_MAPPING_ACC acc

53: --Delete cursor
54: CURSOR csr_rescode_map_del
55: IS
56: SELECT access_id
57: FROM CSM_RESCODE_MAPPING_ACC acc
58: WHERE NOT EXISTS
59: (SELECT 1
60: FROM CS_SR_RES_CODE_MAPPING_DETAIL b
61: WHERE b.resolution_map_detail_id = acc.resolution_map_detail_id

Line 111: DELETE FROM csm_rescode_mapping_acc WHERE access_id = l_map_access_list(i);

107: END LOOP;
108:
109: -- bulk delete from acc table
110: FORALL i IN 1..l_map_access_list.count
111: DELETE FROM csm_rescode_mapping_acc WHERE access_id = l_map_access_list(i);
112:
113: l_map_access_list.delete;
114: END IF; -- end of process deletes
115:

Line 163: INSERT INTO CSM_RESCODE_MAPPING_ACC

159: END LOOP;
160: END LOOP;
161:
162: FORALL i IN 1..l_map_access_list.count
163: INSERT INTO CSM_RESCODE_MAPPING_ACC
164: (access_id,
165: resolution_map_detail_id,
166: created_by,
167: creation_date,