APPS.HRI_OPL_PER_ORGCC dependencies on HRI_CS_PER_ORGCC_V

Line 272: FROM hri_cs_per_orgcc_v svw

268: ,effective_end_date
269: ,company_code
270: ,reporting_name
271: ,last_change_date
272: FROM hri_cs_per_orgcc_v svw
273: --
274: -- 4303724, Used TRUNC function
275: --
276: WHERE TRUNC(last_change_date) BETWEEN g_start_date

Line 306: FROM hri_cs_per_orgcc_v svw

302: ,svw.effective_end_date
303: ,svw.company_code
304: ,svw.reporting_name
305: ,svw.last_change_date
306: FROM hri_cs_per_orgcc_v svw
307: --
308: -- 4303724, Used TRUNC function
309: --
310: WHERE TRUNC(svw.last_change_date) BETWEEN g_start_date

Line 323: FROM hri_cs_per_orgcc_v svw

319: IN
320: (SELECT svw.organization_id,
321: svw.effective_start_date,
322: svw.effective_end_date
323: FROM hri_cs_per_orgcc_v svw
324: --
325: -- 4303724, Used TRUNC function
326: --
327: WHERE TRUNC(svw.last_change_date) BETWEEN g_start_date

Line 338: FROM hri_cs_per_orgcc_v svw

334: -- log('Doing delete.');
335: DELETE
336: FROM hri_cs_per_orgcc_ct tbl
337: WHERE NOT EXISTS (SELECT 'x'
338: FROM hri_cs_per_orgcc_v svw
339: WHERE svw.organization_id = tbl.organization_id
340: AND svw.effective_start_date = tbl.effective_start_date
341: AND svw.effective_end_date = tbl.effective_end_date);
342: -- log('Delete >'||TO_CHAR(sql%rowcount));

Line 384: FROM hri_cs_per_orgcc_v svw;

380: ,effective_end_date
381: ,company_code
382: ,reporting_name
383: ,last_change_date
384: FROM hri_cs_per_orgcc_v svw;
385: --
386: -- @@Code specific to this view/table below ENDS
387: --
388: l_exit_main_loop BOOLEAN := FALSE;