[Home] [Help]
APPS.HRI_OPL_EVENT_CAPTURE dependencies on HRI_MB_WRKFC_EVT_CT
Line 312: hri_mb_wrkfc_evt_ct
308: SELECT DISTINCT
309: asg_assgnmnt_fk
310: ,add_months(trunc(g_capture_from_date,'MONTH'), 1)
311: FROM
312: hri_mb_wrkfc_evt_ct
313: WHERE g_capture_from_date <= time_day_evt_end_fk
314: AND add_months(trunc(sysdate,'MONTH'), 1) > time_day_evt_fk
315: AND term_or_end_ind = 0;
316: