DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RCD_IN_FILE

Line 197: ben_ext_rcd_in_file f,

193: SELECT r.name name,
194: count(d.ext_rslt_dtl_id) count
195: FROM ben_ext_rslt_dtl d,
196: ben_ext_rcd r,
197: ben_ext_rcd_in_file f,
198: ben_ext_rslt rs,
199: ben_ext_dfn df
200: WHERE d.ext_rslt_id(+) = p_ext_rslt_id
201: AND f.ext_rcd_id = r.ext_rcd_id

Line 215: ben_ext_rcd_in_file f,

211: SELECT r.name name,
212: count(d.ext_rslt_dtl_id) count
213: FROM ben_ext_rslt_dtl d,
214: ben_ext_rcd r,
215: ben_ext_rcd_in_file f,
216: ben_ext_rslt rs,
217: ben_ext_dfn df
218: WHERE d.ext_rslt_id(+) = p_ext_rslt_id
219: AND d.request_id(+) = p_request_id

Line 242: ben_ext_rcd_in_file f,

238: --New cursor version 115.26
239: CURSOR csr_get_count(p_name in varchar2)IS
240: SELECT count(r.name) count
241: FROM ben_ext_rcd r,
242: ben_ext_rcd_in_file f,
243: ben_ext_rslt rs,
244: ben_ext_dfn df
245: WHERE f.ext_rcd_id = r.ext_rcd_id
246: AND f.ext_file_id = df.ext_file_id