APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_BUS_DOC_EVENTS_B

Line 364: FROM okc_bus_doc_events_b

360: IS
361: BEGIN
362: SELECT before_after
363: INTO x_before_after
364: FROM okc_bus_doc_events_b
365: WHERE bus_doc_event_id = p_event_id;
366: EXCEPTION
367: WHEN OTHERS
368: THEN

Line 423: FROM okc_bus_doc_events_b start_event,

419: IS
420: CURSOR cur_val_event
421: IS
422: SELECT 'Y'
423: FROM okc_bus_doc_events_b start_event,
424: okc_bus_doc_events_b end_event
425: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
426: AND end_event.bus_doc_event_id = p_end_event_id --end event id
427: AND start_event.bus_doc_type = end_event.bus_doc_type

Line 424: okc_bus_doc_events_b end_event

420: CURSOR cur_val_event
421: IS
422: SELECT 'Y'
423: FROM okc_bus_doc_events_b start_event,
424: okc_bus_doc_events_b end_event
425: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
426: AND end_event.bus_doc_event_id = p_end_event_id --end event id
427: AND start_event.bus_doc_type = end_event.bus_doc_type
428: UNION

Line 430: FROM okc_bus_doc_events_b start_event,

426: AND end_event.bus_doc_event_id = p_end_event_id --end event id
427: AND start_event.bus_doc_type = end_event.bus_doc_type
428: UNION
429: SELECT 'Y'
430: FROM okc_bus_doc_events_b start_event,
431: okc_bus_doc_events_b end_event,
432: okc_bus_doc_types_b end_type
433: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
434: AND end_event.bus_doc_event_id = p_end_event_id --end event id

Line 431: okc_bus_doc_events_b end_event,

427: AND start_event.bus_doc_type = end_event.bus_doc_type
428: UNION
429: SELECT 'Y'
430: FROM okc_bus_doc_events_b start_event,
431: okc_bus_doc_events_b end_event,
432: okc_bus_doc_types_b end_type
433: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
434: AND end_event.bus_doc_event_id = p_end_event_id --end event id
435: AND end_type.document_type = end_event.bus_doc_type

Line 439: FROM okc_bus_doc_events_b start_event,

435: AND end_type.document_type = end_event.bus_doc_type
436: AND start_event.bus_doc_type = end_type.target_response_doc_type
437: UNION
438: SELECT 'Y'
439: FROM okc_bus_doc_events_b start_event,
440: okc_bus_doc_events_b end_event,
441: okc_bus_doc_types_b start_type
442: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
443: AND end_event.bus_doc_event_id = p_end_event_id --end event id

Line 440: okc_bus_doc_events_b end_event,

436: AND start_event.bus_doc_type = end_type.target_response_doc_type
437: UNION
438: SELECT 'Y'
439: FROM okc_bus_doc_events_b start_event,
440: okc_bus_doc_events_b end_event,
441: okc_bus_doc_types_b start_type
442: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
443: AND end_event.bus_doc_event_id = p_end_event_id --end event id
444: AND start_type.document_type = start_event.bus_doc_type

Line 4469: FROM okc_bus_doc_events_b

4465: THEN
4466: BEGIN
4467: SELECT business_event_code, before_after, 'Y'
4468: INTO l_starteventcode, l_startba, l_continue
4469: FROM okc_bus_doc_events_b
4470: WHERE bus_doc_event_id =
4471: p_deliverable_rec.relative_st_date_event_id;
4472: EXCEPTION
4473: WHEN NO_DATA_FOUND

Line 4483: FROM okc_bus_doc_events_b

4479: THEN
4480: BEGIN
4481: SELECT business_event_code, before_after, 'Y'
4482: INTO l_endeventcode, l_endba, l_continue
4483: FROM okc_bus_doc_events_b
4484: WHERE bus_doc_event_id =
4485: p_deliverable_rec.relative_end_date_event_id;
4486: EXCEPTION
4487: WHEN NO_DATA_FOUND