APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RCD

Line 198: ben_ext_rcd r,

194: CURSOR csr_get_rec_tot_rslt IS
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

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 216: ben_ext_rcd r,

212: CURSOR csr_get_rec_tot_both IS
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

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 234: ,ben_ext_rcd b

230: cursor csr_get_rec_tot_req is
231: SELECT b.name rec_name
232: ,count(ext_rslt_dtl_id)
233: FROM ben_ext_rslt_dtl a
234: ,ben_ext_rcd b
235: WHERE a.ext_rcd_id = b.ext_rcd_id
236: AND a.ext_rslt_id = p_ext_rslt_id --a.request_id = p_request_id
237: GROUP BY b.name
238: ORDER BY upper(b.name);

Line 243: FROM ben_ext_rcd r,

239: --
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

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

Line 256: l_name ben_ext_rcd.name%type;

252: GROUP BY r.name;
253: --
254: l_counter number := 0;
255: l_count number;
256: l_name ben_ext_rcd.name%type;
257: l_num number;
258: l_proc varchar2(72) := g_package||'.get_rec_nam_num';
259: --
260: begin

Line 343: ,ben_ext_rcd b

339: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
340: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
341: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
342: FROM ben_ext_rslt_dtl a
343: ,ben_ext_rcd b
344: WHERE a.ext_rcd_id = b.ext_rcd_id
345: AND a.ext_rslt_id = p_ext_rslt_id;
346: --
347: cursor csr_get_rec_statistics_req is

Line 352: ,ben_ext_rcd b

348: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
349: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
350: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
351: FROM ben_ext_rslt_dtl a
352: ,ben_ext_rcd b
353: WHERE a.ext_rcd_id = b.ext_rcd_id
354: AND a.ext_rslt_id = p_ext_rslt_id; --a.request_id = p_request_id;
355: --
356: cursor csr_get_rec_statistics_both is

Line 361: ,ben_ext_rcd b

357: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
358: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
359: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
360: FROM ben_ext_rslt_dtl a
361: ,ben_ext_rcd b
362: WHERE a.ext_rcd_id = b.ext_rcd_id
363: AND a.request_id = p_request_id
364: AND a.ext_rslt_id = p_ext_rslt_id;
365: --