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.PQP_US_PENSION_EXTRACTS dependencies on BEN_EXT_RCD_IN_FILE

Line 232: ,ben_ext_rcd_in_file rin

228: ,c_rcd_type_cd IN VARCHAR2
229: ) IS
230: SELECT rcd.ext_rcd_id
231: FROM ben_ext_rcd rcd
232: ,ben_ext_rcd_in_file rin
233: ,ben_ext_dfn dfn
234: WHERE dfn.ext_dfn_id = Ben_Ext_Thread.g_ext_dfn_id -- The extract executing currently
235: AND rin.ext_file_id = dfn.ext_file_id
236: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 2843: FROM ben_ext_rcd_in_file rif

2839: ,rif.any_or_all_cd
2840: ,rif.seq_num
2841: ,rif.sprs_cd
2842: ,rif.rqd_flag
2843: FROM ben_ext_rcd_in_file rif
2844: ,ben_ext_dfn dfn
2845: WHERE rif.ext_file_id = dfn.ext_file_id
2846: AND rif.ext_rcd_id = c_rcd_id
2847: AND dfn.ext_dfn_id = c_ext_dfn_id;