APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 3283: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

3279: IS
3280: SELECT COUNT(*)
3281: FROM ben_ext_rslt_dtl dtl
3282: --,ben_ext_rcd rcd
3283: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
3284: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3285: --AND rcd.rcd_type_cd = 'D'
3286: AND dtl.ext_rcd_id = p_ext_rcd_id
3287: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)