APPS.BEN_EXTRACT dependencies on BEN_EXT_RCD_IN_FILE

Line 32: ben_ext_rcd_in_file b

28: )
29: is
30: select distinct a.low_lvl_cd
31: from ben_ext_rcd a,
32: ben_ext_rcd_in_file b
33: where a.ext_rcd_id = b.ext_rcd_id
34: and b.ext_file_id = p_ext_file_id
35: and b.rqd_flag = 'Y'
36: -- Bug fix 1702733 - header/trailer type records should not be checked for required flag = 'Y' here

Line 55: ben_ext_rcd_in_file b

51: )
52: is
53: select a.low_lvl_cd,b.seq_num
54: from ben_ext_rcd a,
55: ben_ext_rcd_in_file b
56: where a.ext_rcd_id = b.ext_rcd_id
57: and b.ext_file_id = p_ext_file_id
58: and b.rqd_flag = 'Y'
59: and a.rcd_type_cd in ( 'D','S') ; -- subheader

Line 81: ben_ext_rcd_in_file b

77: b.any_or_all_cd,
78: a.rcd_type_cd,
79: a.low_lvl_cd
80: from ben_ext_rcd a,
81: ben_ext_rcd_in_file b
82: where a.ext_rcd_id = b.ext_rcd_id
83: and b.ext_file_id = p_ext_file_id
84: order by b.seq_num;
85:

Line 578: ben_ext_rcd_in_file b

574: decode(sum(decode(a.low_lvl_cd,'PY',1,0)),0,'N','Y') g_pay_lvl, -- subheader
575: decode(sum(decode(a.low_lvl_cd,'T',1,0)),0,'N','Y') g_otl_summ_lvl,
576: decode(sum(decode(a.low_lvl_cd,'TS',1,0)),0,'N','Y') g_otl_detl_lvl
577: from ben_ext_rcd a,
578: ben_ext_rcd_in_file b
579: where a.ext_rcd_id = b.ext_rcd_id
580: and b.ext_file_id = p_ext_file_id;
581:
582: cursor ext_cursors_c (p_ext_file_id number) is

Line 639: from ben_ext_rcd_in_file a,

635: decode(sum(decode(e.csr_cd,'SHL',1,0)),0,'N','Y') g_shl_csr,
636: decode(sum(decode(e.csr_cd,'CWPG',1,0)),0,'N','Y') g_cwbdg_csr ,
637: decode(sum(decode(e.csr_cd,'CWPR',1,0)),0,'N','Y') g_cwbawr_csr,
638: decode(sum(decode(e.csr_cd,'CBRADM',1,0)),0,'N','Y') g_cbradm_csr
639: from ben_ext_rcd_in_file a,
640: ben_ext_rcd b,
641: ben_ext_data_elmt_in_rcd c,
642: ben_ext_data_elmt d,
643: ben_ext_fld e