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_IN_FILE

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