244: l_count NUMBER;
245:
246:
247: CURSOR get_source_doc_info(
248: c_application_id zx_evnt_cls_mappings.application_id%TYPE,
249: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
250: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE
251: )
252: IS
245:
246:
247: CURSOR get_source_doc_info(
248: c_application_id zx_evnt_cls_mappings.application_id%TYPE,
249: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
250: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE
251: )
252: IS
253: SELECT intrcmp_src_appln_id,
246:
247: CURSOR get_source_doc_info(
248: c_application_id zx_evnt_cls_mappings.application_id%TYPE,
249: c_entity_code zx_evnt_cls_mappings.entity_code%TYPE,
250: c_event_class_code zx_evnt_cls_mappings.event_class_code%TYPE
251: )
252: IS
253: SELECT intrcmp_src_appln_id,
254: intrcmp_src_entity_code,
252: IS
253: SELECT intrcmp_src_appln_id,
254: intrcmp_src_entity_code,
255: intrcmp_src_evnt_cls_code
256: FROM zx_evnt_cls_mappings
257: WHERE application_id = c_application_id
258: AND entity_code = c_entity_code
259: AND event_class_code = c_event_class_code;
260: