DBA Data[Home] [Help]

APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RCD_IN_FILE

Line 199: ben_ext_rcd_in_file f,

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

Line 217: ben_ext_rcd_in_file f,

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

Line 244: ben_ext_rcd_in_file f,

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