APPS.CSM_PROBCODE_MAPPING_EVENT_PKG dependencies on CSM_PROBCODE_MAPPING_ACC

Line 36: SELECT csm_probcode_mapping_acc_s.nextval,

32:
33: -- Cursor Declaration
34: CURSOR csr_probcode_map_ins
35: IS
36: SELECT csm_probcode_mapping_acc_s.nextval,
37: b.problem_map_detail_id
38: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b
39: WHERE NOT EXISTS
40: (

Line 42: FROM CSM_PROBCODE_MAPPING_ACC acc

38: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b
39: WHERE NOT EXISTS
40: (
41: SELECT 1
42: FROM CSM_PROBCODE_MAPPING_ACC acc
43: WHERE acc.problem_map_detail_id = b.problem_map_detail_id
44: );
45:
46: --Update Cursor

Line 50: FROM CSM_PROBCODE_MAPPING_ACC acc,

46: --Update Cursor
47: CURSOR csr_probcode_map_upd(p_lastrundate IN date)
48: IS
49: SELECT access_id
50: FROM CSM_PROBCODE_MAPPING_ACC acc,
51: CS_SR_PROB_CODE_MAPPING_DETAIL b
52: WHERE acc.problem_map_detail_id = b.problem_map_detail_id
53: AND b.last_update_date >= p_lastrundate;
54:

Line 59: FROM CSM_PROBCODE_MAPPING_ACC acc

55: --Delete Cursor
56: CURSOR csr_probcode_map_del
57: IS
58: SELECT access_id
59: FROM CSM_PROBCODE_MAPPING_ACC acc
60: WHERE NOT EXISTS
61: (SELECT 1
62: FROM CS_SR_PROB_CODE_MAPPING_DETAIL b
63: WHERE b.problem_map_detail_id = acc.problem_map_detail_id

Line 115: DELETE FROM csm_probcode_mapping_acc WHERE access_id = l_map_access_list(i);

111: END LOOP;
112:
113: -- bulk delete from acc table
114: FORALL i IN 1..l_map_access_list.count
115: DELETE FROM csm_probcode_mapping_acc WHERE access_id = l_map_access_list(i);
116:
117: l_map_access_list.delete;
118: END IF; -- end of process deletes
119:

Line 166: INSERT INTO csm_probcode_mapping_acc

162: END LOOP;
163: END LOOP;
164:
165: FORALL i IN 1..l_map_access_list.count
166: INSERT INTO csm_probcode_mapping_acc
167: (access_id,
168: problem_map_detail_id,
169: created_by, creation_date,
170: last_updated_by,