DBA Data[Home] [Help]

APPS.HR_EDW_WRK_RCTMNT_F_C dependencies on HR_EDW_WRK_RCTMNT_FCV

Line 287: from HR_EDW_WRK_RCTMNT_FCV

283: interview2_pass_occurred,
284: interview2_fail_occurred,
285: offer_fail_occurred,
286: accept_fail_occurred
287: from HR_EDW_WRK_RCTMNT_FCV
288: where last_update_date between l_date1 and l_date2;
289: l_rows_inserted := sql%rowcount;
290: COMMIT;
291: l_duration := sysdate - l_temp_date;

Line 295: to HR_EDW_WRK_RCTMNT_FCV */

291: l_duration := sysdate - l_temp_date;
292: /*Above where clause should be replaced in future when complete fix
293: available for bug 2418020 with the commented lines below.
294: For this to happen effective_start_date needs to be added
295: to HR_EDW_WRK_RCTMNT_FCV */
296: /* comment in as described above in later release
297: WHERE last_update_date BETWEEN l_date1 AND l_date2
298: AND effective_start_date between l_date1 AND l_date2;
299: */