APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RSLT_DTL

Line 195: FROM ben_ext_rslt_dtl d,

191: --Modified cursor version 115.26
192: CURSOR csr_get_rec_tot_rslt IS
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

Line 213: FROM ben_ext_rslt_dtl d,

209: --Modified cursor version 115.26
210: CURSOR csr_get_rec_tot_both IS
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

Line 231: FROM ben_ext_rslt_dtl a

227: --
228: cursor csr_get_rec_tot_req is
229: SELECT b.name rec_name
230: ,count(ext_rslt_dtl_id)
231: FROM ben_ext_rslt_dtl a
232: ,ben_ext_rcd b
233: WHERE a.ext_rcd_id = b.ext_rcd_id
234: AND a.ext_rslt_id = p_ext_rslt_id --a.request_id = p_request_id
235: GROUP BY b.name

Line 340: FROM ben_ext_rslt_dtl a

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

Line 349: FROM ben_ext_rslt_dtl a

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

Line 358: FROM ben_ext_rslt_dtl a

354: cursor csr_get_rec_statistics_both is
355: SELECT count(decode(b.rcd_type_cd, 'H', b.rcd_type_cd))
356: ,count(decode(b.rcd_type_cd, 'D', b.rcd_type_cd))
357: ,count(decode(b.rcd_type_cd, 'T', b.rcd_type_cd))
358: FROM ben_ext_rslt_dtl a
359: ,ben_ext_rcd b
360: WHERE a.ext_rcd_id = b.ext_rcd_id
361: AND a.request_id = p_request_id
362: AND a.ext_rslt_id = p_ext_rslt_id;

Line 414: FROM ben_ext_rslt_dtl

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

Line 421: FROM ben_ext_rslt_dtl

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

Line 809: ' FROM ben_ext_rslt_dtl ' ||

805: l_char_seq_num := to_char(p_seq_num);
806: end if;
807: --
808: l_string := 'SELECT val_' || l_char_seq_num ||
809: ' FROM ben_ext_rslt_dtl ' ||
810: 'WHERE ext_rslt_dtl_id = ' ||
811: to_char(p_ext_rslt_dtl_id);
812: --
813: l_cid := DBMS_SQL.OPEN_CURSOR;