APPS.OKC_TERMS_MIGRATE_GRP dependencies on OKC_BUS_DOC_EVENTS_B

Line 3544: FROM okc_bus_doc_events_b

3540: IS
3541: BEGIN
3542: SELECT before_after
3543: INTO x_before_after
3544: FROM okc_bus_doc_events_b
3545: WHERE bus_doc_event_id = p_event_id;
3546: EXCEPTION
3547: WHEN OTHERS
3548: THEN

Line 3728: FROM okc_bus_doc_events_b start_event,

3724: IS
3725: CURSOR cur_val_event
3726: IS
3727: SELECT 'Y'
3728: FROM okc_bus_doc_events_b start_event,
3729: okc_bus_doc_events_b end_event
3730: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3731: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3732: AND start_event.bus_doc_type = end_event.bus_doc_type

Line 3729: okc_bus_doc_events_b end_event

3725: CURSOR cur_val_event
3726: IS
3727: SELECT 'Y'
3728: FROM okc_bus_doc_events_b start_event,
3729: okc_bus_doc_events_b end_event
3730: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3731: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3732: AND start_event.bus_doc_type = end_event.bus_doc_type
3733: UNION

Line 3735: FROM okc_bus_doc_events_b start_event,

3731: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3732: AND start_event.bus_doc_type = end_event.bus_doc_type
3733: UNION
3734: SELECT 'Y'
3735: FROM okc_bus_doc_events_b start_event,
3736: okc_bus_doc_events_b end_event,
3737: okc_bus_doc_types_b end_type
3738: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3739: AND end_event.bus_doc_event_id = p_end_event_id --end event id

Line 3736: okc_bus_doc_events_b end_event,

3732: AND start_event.bus_doc_type = end_event.bus_doc_type
3733: UNION
3734: SELECT 'Y'
3735: FROM okc_bus_doc_events_b start_event,
3736: okc_bus_doc_events_b end_event,
3737: okc_bus_doc_types_b end_type
3738: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3739: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3740: AND end_type.document_type = end_event.bus_doc_type

Line 3744: FROM okc_bus_doc_events_b start_event,

3740: AND end_type.document_type = end_event.bus_doc_type
3741: AND start_event.bus_doc_type = end_type.target_response_doc_type
3742: UNION
3743: SELECT 'Y'
3744: FROM okc_bus_doc_events_b start_event,
3745: okc_bus_doc_events_b end_event,
3746: okc_bus_doc_types_b start_type
3747: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3748: AND end_event.bus_doc_event_id = p_end_event_id --end event id

Line 3745: okc_bus_doc_events_b end_event,

3741: AND start_event.bus_doc_type = end_type.target_response_doc_type
3742: UNION
3743: SELECT 'Y'
3744: FROM okc_bus_doc_events_b start_event,
3745: okc_bus_doc_events_b end_event,
3746: okc_bus_doc_types_b start_type
3747: WHERE start_event.bus_doc_event_id = p_st_event_id --start event id
3748: AND end_event.bus_doc_event_id = p_end_event_id --end event id
3749: AND start_type.document_type = start_event.bus_doc_type

Line 5013: FROM okc_bus_doc_events_b

5009: THEN
5010: BEGIN
5011: SELECT business_event_code, before_after, 'Y'
5012: INTO l_starteventcode, l_startba, l_continue
5013: FROM okc_bus_doc_events_b
5014: WHERE bus_doc_event_id =
5015: p_deliverable_rec.relative_st_date_event_id;
5016: EXCEPTION
5017: WHEN NO_DATA_FOUND

Line 5027: FROM okc_bus_doc_events_b

5023: THEN
5024: BEGIN
5025: SELECT business_event_code, before_after, 'Y'
5026: INTO l_endeventcode, l_endba, l_continue
5027: FROM okc_bus_doc_events_b
5028: WHERE bus_doc_event_id =
5029: p_deliverable_rec.relative_end_date_event_id;
5030: EXCEPTION
5031: WHEN NO_DATA_FOUND