DBA Data[Home] [Help]

APPS.OKC_TERMS_MIGRATE_GRP dependencies on OKC_BUS_DOC_EVENTS_V

Line 3876: FROM okc_bus_doc_events_v evts,

3872: IS
3873: CURSOR cur_val_event
3874: IS
3875: SELECT 'Y'
3876: FROM okc_bus_doc_events_v evts,
3877: okc_bus_doc_types_b doctypes,
3878: okc_del_bus_doc_combxns delcomb,
3879: okc_deliverable_types_b deltypes
3880: WHERE evts.bus_doc_event_id = p_bus_doc_event_id

Line 3891: FROM okc_bus_doc_events_v evts,

3887: OR evts.start_end_qualifier = 'START'
3888: )
3889: UNION
3890: SELECT 'Y'
3891: FROM okc_bus_doc_events_v evts,
3892: okc_bus_doc_types_b doctypes,
3893: okc_del_bus_doc_combxns delcomb,
3894: okc_deliverable_types_b deltypes
3895: WHERE evts.bus_doc_event_id = p_bus_doc_event_id

Line 3906: FROM okc_bus_doc_events_v evts,

3902: OR evts.start_end_qualifier = 'START'
3903: )
3904: UNION
3905: SELECT 'Y'
3906: FROM okc_bus_doc_events_v evts,
3907: okc_bus_doc_types_b doctypes,
3908: okc_del_bus_doc_combxns delcomb,
3909: okc_deliverable_types_b deltypes
3910: WHERE 1=1

Line 3952: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

3948:
3949: CURSOR cur_val_event
3950: IS
3951: select 'Y'
3952: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3953: okc_del_bus_doc_combxns delComb,
3954: okc_deliverable_types_b delTypes
3955: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3956: AND delTypes.deliverable_type_code = p_deliverable_type

Line 3966: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

3962:
3963: UNION
3964:
3965: select 'Y'
3966: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3967: okc_del_bus_doc_combxns delComb,
3968: okc_deliverable_types_b delTypes
3969: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3970: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType

Line 3980: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

3976:
3977: UNION
3978:
3979: select 'Y'
3980: from okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
3981: okc_del_bus_doc_combxns delComb,
3982: okc_deliverable_types_b delTypes
3983: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
3984: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType

Line 3994: from okc_bus_doc_events_v evts,

3990:
3991: UNION
3992:
3993: select 'Y'
3994: from okc_bus_doc_events_v evts,
3995: okc_bus_doc_types_b doc_types,
3996: okc_del_bus_doc_combxns delComb,
3997: okc_deliverable_types_b del_types
3998:

Line 4010: FROM okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,

4006:
4007: UNION
4008:
4009: select 'Y'
4010: FROM okc_bus_doc_events_v evts, okc_bus_doc_types_b docTypes,
4011: okc_del_bus_doc_combxns delComb,
4012: okc_deliverable_types_b delTypes
4013: WHERE evts.bus_doc_event_id = p_bus_doc_event_id
4014: AND delTypes.deliverable_type_code = p_deliverable_type --- :selectedDeliverableType