APPS.OKC_AQ_PVT dependencies on AQ$_OKC_AQ_EV_TAB_H

Line 490: from AQ$_OKC_AQ_EV_TAB_H h,

486: IS
487: SELECT h.msgid msgid ,
488: decode(h.subscriber#,0
489: ,decode(h.name,'0',NULL,h.name),s.name) consumer_name
490: from AQ$_OKC_AQ_EV_TAB_H h,
491: aq$_okc_aq_ev_tab_s s,
492: okc_aq_ev_tab q
493: WHERE q.q_name = substr(p_queue,5)
494: and q.STATE = 0

Line 563: from AQ$_OKC_AQ_EV_TAB_H h,

559: IS
560: SELECT h.msgid msgid ,
561: decode(h.subscriber#,0
562: ,decode(h.name,'0',NULL,h.name),s.name) consumer_name
563: from AQ$_OKC_AQ_EV_TAB_H h,
564: aq$_okc_aq_ev_tab_s s,
565: okc_aq_ev_tab q
566: WHERE q.q_name = substr(p_queue,5)
567: and q.STATE = 0