APPS.XDP_ADAPTER_CORE_DB dependencies on XDP_ADAPTER_JOB_QUEUE

Line 698: FROM xdp_adapter_job_queue xaj, xdp_adapter_reg xar, xdp_adapter_types_b xat

694: else
695:
696: SELECT COUNT(DISTINCT xaj.job_id) num_of_jobs
697: INTO l_num_of_job_cnt
698: FROM xdp_adapter_job_queue xaj, xdp_adapter_reg xar, xdp_adapter_types_b xat
699: WHERE xaj.fe_id = xar.fe_id
700: AND xar.adapter_type = xat.adapter_type
701: AND xaj.fe_id = p_fe_id
702: AND xat.application_mode <> 'QUEUE';

Line 859: ( select JOB_ID from xdp_adapter_job_queue a, xdp_adapter_reg b

855: begin
856: select 'Y' into l_check
857: from dual
858: where exists
859: ( select JOB_ID from xdp_adapter_job_queue a, xdp_adapter_reg b
860: where b.channel_name = p_ChannelName
861: and b.fe_id = a.fe_id);
862: exception
863: when no_data_found then