APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RSLT_DTL

Line 197: FROM ben_ext_rslt_dtl d,

193: --Modified cursor version 115.26
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

Line 215: FROM ben_ext_rslt_dtl d,

211: --Modified cursor version 115.26
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

Line 233: FROM ben_ext_rslt_dtl a

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

Line 342: FROM ben_ext_rslt_dtl a

338: cursor csr_get_rec_statistics_rslt is
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: --

Line 351: FROM ben_ext_rslt_dtl a

347: cursor csr_get_rec_statistics_req is
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: --

Line 360: FROM ben_ext_rslt_dtl a

356: cursor csr_get_rec_statistics_both is
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;

Line 416: FROM ben_ext_rslt_dtl

412: l_proc varchar2(72) := g_package||'.get_per_statistics';
413: --
414: cursor csr_get_per_xtrctd_rslt is
415: SELECT count(distinct person_id)
416: FROM ben_ext_rslt_dtl
417: WHERE ext_rslt_id = p_ext_rslt_id
418: AND person_id not in (0, 999999999999);
419:
420: --

Line 423: FROM ben_ext_rslt_dtl

419:
420: --
421: cursor csr_get_per_xtrctd_req is
422: SELECT count(distinct person_id)
423: FROM ben_ext_rslt_dtl
424: WHERE ext_rslt_id = p_ext_rslt_id --request_id = p_request_id
425: AND person_id not in (0, 999999999999);
426: --
427: cursor csr_get_per_not_xtrctd_req is

Line 811: ' FROM ben_ext_rslt_dtl ' ||

807: l_char_seq_num := to_char(p_seq_num);
808: end if;
809: --
810: l_string := 'SELECT val_' || l_char_seq_num ||
811: ' FROM ben_ext_rslt_dtl ' ||
812: 'WHERE ext_rslt_dtl_id = :b1'; -- Bug 14482456:
813: -- For Memory issues, used bind parameter in dynamic sql
814: --to_char(p_ext_rslt_dtl_id);
815: --