eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_US_NFC_EXTRACTS dependencies on BEN_EXT_RCD

Line 61: FROM ben_ext_rcd rcd

57: -- =============================================================================
58: CURSOR csr_ext_rcd_id(c_hide_flag IN VARCHAR2
59: ,c_rcd_type_cd IN VARCHAR2) IS
60: SELECT rcd.ext_rcd_id
61: FROM ben_ext_rcd rcd
62: ,ben_ext_rcd_in_file rin
63: ,ben_ext_dfn dfn
64: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
65: AND rin.ext_file_id = dfn.ext_file_id

Line 62: ,ben_ext_rcd_in_file rin

58: CURSOR csr_ext_rcd_id(c_hide_flag IN VARCHAR2
59: ,c_rcd_type_cd IN VARCHAR2) IS
60: SELECT rcd.ext_rcd_id
61: FROM ben_ext_rcd rcd
62: ,ben_ext_rcd_in_file rin
63: ,ben_ext_dfn dfn
64: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
65: AND rin.ext_file_id = dfn.ext_file_id
66: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 175: FROM ben_ext_rcd rcd

171: CURSOR csr_ext_rcd(c_hide_flag in varchar2
172: ,c_rcd_type_cd in varchar2
173: ) is
174: SELECT rcd.ext_rcd_id
175: FROM ben_ext_rcd rcd
176: ,ben_ext_rcd_in_file rin
177: ,ben_ext_dfn dfn
178: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
179: AND rin.ext_file_id = dfn.ext_file_id

Line 176: ,ben_ext_rcd_in_file rin

172: ,c_rcd_type_cd in varchar2
173: ) is
174: SELECT rcd.ext_rcd_id
175: FROM ben_ext_rcd rcd
176: ,ben_ext_rcd_in_file rin
177: ,ben_ext_dfn dfn
178: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
179: AND rin.ext_file_id = dfn.ext_file_id
180: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 3774: (p_ext_rcd_id in ben_ext_rcd.ext_rcd_id%type

3770: -- =============================================================================
3771: -- ~ Update_Record_Values :
3772: -- =============================================================================
3773: procedure Update_Record_Values
3774: (p_ext_rcd_id in ben_ext_rcd.ext_rcd_id%type
3775: ,p_ext_data_element_name in ben_ext_data_elmt.name%type
3776: ,p_data_element_value in ben_ext_rslt_dtl.val_01%type
3777: ,p_data_ele_seqnum in number
3778: ,p_ext_dtl_rec in out nocopy ben_ext_rslt_dtl%rowtype

Line 3780: cursor csr_seqnum (c_ext_rcd_id in ben_ext_rcd.ext_rcd_id%type

3776: ,p_data_element_value in ben_ext_rslt_dtl.val_01%type
3777: ,p_data_ele_seqnum in number
3778: ,p_ext_dtl_rec in out nocopy ben_ext_rslt_dtl%rowtype
3779: ) is
3780: cursor csr_seqnum (c_ext_rcd_id in ben_ext_rcd.ext_rcd_id%type
3781: ,c_ext_data_element_name in ben_ext_data_elmt.name%type
3782: ) is
3783: select der.ext_data_elmt_id,
3784: der.seq_num,

Line 4488: ben_ext_rcd xrc,

4484: xel.ext_fld_id,
4485: fld.frmt_mask_typ_cd
4486: from ben_ext_where_clause xwc,
4487: ben_ext_data_elmt_in_rcd xer,
4488: ben_ext_rcd xrc,
4489: ben_ext_data_elmt xel,
4490: ben_ext_fld fld
4491: where xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id
4492: and xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id

Line 4503: l_rcd_name ben_ext_rcd.name%type ;

4499: l_condition varchar2(1);
4500: l_cnt number;
4501: l_value_without_quotes varchar2(500);
4502: l_dynamic_condition varchar2(9999);
4503: l_rcd_name ben_ext_rcd.name%type ;
4504: --
4505: --
4506: begin
4507: --

Line 5245: from ben_ext_rcd_in_file rif

5241: ,rif.any_or_all_cd
5242: ,rif.seq_num
5243: ,rif.sprs_cd
5244: ,rif.rqd_flag
5245: from ben_ext_rcd_in_file rif
5246: ,ben_ext_dfn dfn
5247: where rif.ext_file_id = dfn.ext_file_id
5248: and rif.ext_rcd_id = c_rcd_id
5249: and dfn.ext_dfn_id = c_ext_dfn_id;