APPS.CSM_LOOKUP_EVENT_PKG dependencies on CSM_LOOKUPS_ACC

Line 103: FROM csm_lookups_acc acc

99: OR (val.view_application_id = 0 AND val.lookup_type IN ('MISCS_DOA_TYPE','MISCS_DETECTION_CODE','MISCS_FAULT_TYPE','MISCS_FIELD_SYMPTOM_CODES'))
100: )
101: AND NOT EXISTS
102: (SELECT 1
103: FROM csm_lookups_acc acc
104: WHERE acc.lookup_type = val.lookup_type
105: AND acc.language = val.language
106: AND acc.lookup_code = val.lookup_code
107: AND acc.security_group_id = val.security_group_id

Line 121: csm_lookups_acc acc

117: val.security_group_id,
118: val.language,
119: val.last_update_date
120: FROM fnd_lookup_values val,
121: csm_lookups_acc acc
122: WHERE acc.lookup_type = val.lookup_type
123: AND acc.language = val.language
124: AND acc.lookup_code = val.lookup_code
125: AND acc.security_group_id = val.security_group_id

Line 140: FROM csm_lookups_acc acc

136: acc.lookup_code,
137: acc.security_group_id,
138: acc.language,
139: acc.last_update_date
140: FROM csm_lookups_acc acc
141: WHERE NOT EXISTS
142: (SELECT 1
143: FROM fnd_lookup_values val
144: WHERE acc.lookup_type = val.lookup_type

Line 184: DELETE FROM csm_lookups_acc WHERE access_id = l_access_id;

180: ASG_DOWNLOAD.DEL, sysdate);
181: END IF;
182:
183: -- delete from acc table
184: DELETE FROM csm_lookups_acc WHERE access_id = l_access_id;
185: END LOOP;
186:
187: -- process all updates
188: FOR r_lookups_upd_rec IN l_lookups_upd_csr(l_prog_update_date) LOOP

Line 218: SELECT csm_lookups_acc_s.nextval

214: --get the users with this language
215: l_tl_omfs_palm_resource_list := l_null_resource_list;
216: l_tl_omfs_palm_resource_list := csm_util_pkg.get_tl_omfs_palm_resources(r_lookups_ins_rec.language);
217:
218: SELECT csm_lookups_acc_s.nextval
219: INTO l_access_id
220: FROM dual;
221:
222: --nullify the access list

Line 235: INSERT INTO csm_lookups_acc (access_id,

231: l_single_access_id_list, l_tl_omfs_palm_resource_list,
232: ASG_DOWNLOAD.INS, sysdate);
233: END IF;
234:
235: INSERT INTO csm_lookups_acc (access_id,
236: lookup_type,
237: language,
238: lookup_code,
239: security_group_id,