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_PENSION_EXTRACTS dependencies on BEN_EXT_RCD_IN_FILE

Line 265: ,ben_ext_rcd_in_file rin

261: ,c_rcd_type_cd IN VARCHAR2
262: ) IS
263: SELECT rcd.ext_rcd_id
264: FROM ben_ext_rcd rcd
265: ,ben_ext_rcd_in_file rin
266: ,ben_ext_dfn dfn
267: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id -- The extract executing currently
268: AND rin.ext_file_id = dfn.ext_file_id
269: AND rin.hide_flag = c_hide_flag -- Y=Hidden, N=Not Hidden

Line 2027: FROM ben_ext_rcd_in_file rif

2023: ,rif.any_or_all_cd
2024: ,rif.seq_num
2025: ,rif.sprs_cd
2026: ,rif.rqd_flag
2027: FROM ben_ext_rcd_in_file rif
2028: ,ben_ext_dfn dfn
2029: WHERE rif.ext_file_id = dfn.ext_file_id
2030: AND rif.ext_rcd_id = c_rcd_id
2031: AND dfn.ext_dfn_id = c_ext_dfn_id;