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 1064: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id

1060: SELECT rcd.ext_rcd_id
1061: FROM ben_ext_rcd rcd
1062: ,ben_ext_rcd_in_file RinF
1063: ,ben_ext_dfn dfn
1064: WHERE dfn.ext_dfn_id = ben_ext_thread.g_ext_dfn_id
1065: AND RinF.ext_file_id = dfn.ext_file_id
1066: AND RinF.hide_flag = p_hide_flag
1067: AND RinF.ext_rcd_id = rcd.ext_rcd_id
1068: AND rcd.rcd_type_cd = p_rcd_type_cd;

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

1128: AND
1129: emd.national_identifier = p_national_identifier
1130: )
1131: )
1132: AND emd.ext_dfn_id = nvl(p_ext_dfn_id, ben_ext_thread.g_ext_dfn_id) --ENH3
1133: AND emd.lea_number = nvl(p_lea_number, g_lea_number); --ENH3
1134:
1135:
1136: -- This cursor returns all BGs which have the p_lea_number