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_GB_T1_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 1055: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id

1051: SELECT rcd.ext_rcd_id
1052: FROM ben_ext_rcd rcd
1053: ,ben_ext_rcd_in_file RinF
1054: ,ben_ext_dfn dfn
1055: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
1056: AND RinF.ext_file_id = dfn.ext_file_id
1057: AND RinF.hide_flag = p_hide_flag
1058: AND RinF.ext_rcd_id = rcd.ext_rcd_id
1059: AND rcd.rcd_type_cd = p_rcd_type_cd;

Line 1111: AND emd.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id) --ENH3

1107: AND
1108: emd.national_identifier = p_national_identifier
1109: )
1110: )
1111: AND emd.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id) --ENH3
1112: AND emd.lea_number = nvl(p_lea_number, g_lea_number); --ENH3
1113:
1114:
1115: -- This cursor returns all BGs which have the p_lea_number