APPS.PQP_GB_TP_PENSION_EXTRACTS dependencies on BEN_EXT_THREAD

Line 3269: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id

3265: IS
3266: SELECT COUNT(*)
3267: FROM ben_ext_rslt_dtl dtl
3268: --,ben_ext_rcd rcd
3269: WHERE dtl.ext_rslt_id = ben_ext_thread.g_ext_rslt_id
3270: --AND rcd.ext_rcd_id = dtl.ext_rcd_id
3271: --AND rcd.rcd_type_cd = 'D'
3272: AND dtl.ext_rcd_id = p_ext_rcd_id
3273: AND DECODE(NVL(TRIM(p_type),hr_api.g_varchar2)