APPS.BEN_EXT_UTIL dependencies on BEN_EXT_RCD

Line 196: ben_ext_rcd r,

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
200: WHERE d.ext_rslt_id(+) = p_ext_rslt_id

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

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
218: WHERE d.ext_rslt_id(+) = p_ext_rslt_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 232: ,ben_ext_rcd b

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
236: ORDER BY upper(b.name);

Line 241: FROM ben_ext_rcd r,

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

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

Line 254: l_name ben_ext_rcd.name%type;

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

Line 341: ,ben_ext_rcd b

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

Line 350: ,ben_ext_rcd b

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

Line 359: ,ben_ext_rcd b

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;
363: --