APPS.PER_ENT_BUS dependencies on PER_CAL_ENTRY_VALUES

Line 503: From per_cal_entry_values env

499: procedure chk_no_entry_values_exist(p_calendar_entry_id in number) IS
500: --
501: CURSOR csr_ev IS
502: Select 'x'
503: From per_cal_entry_values env
504: Where env.calendar_entry_id = p_calendar_entry_id;
505: --
506: l_proc varchar2(72) := g_package||'chk_no_entry_values_exist';
507: l_dummy varchar2(1);

Line 594: AND exists (select 'Y' from per_cal_entry_values env

590: 'H')
591:
592: FROM per_calendar_entries ent
593: WHERE ent.calendar_entry_id = p_calendar_entry_id
594: AND exists (select 'Y' from per_cal_entry_values env
595: where env.calendar_entry_id = p_calendar_entry_id);
596: --
597: l_chk_evs BOOLEAN := FALSE;
598: l_dummy VARCHAR2(1) := NULL;