[Home] [Help]
26: --
27: cursor csr_sec_grp is
28: select pbg.security_group_id
29: from per_business_groups_perf pbg
30: , per_calendar_entries ent
31: , per_cal_entry_values env
32: where env.cal_entry_value_id = p_cal_entry_value_id
33: and env.calendar_entry_id = ent.calendar_entry_id
34: and pbg.business_group_id (+) = ent.business_group_id;
93: --
94: cursor csr_leg_code is
95: select pbg.legislation_code
96: from per_business_groups_perf pbg
97: , per_calendar_entries ent
98: , per_cal_entry_values env
99: where env.cal_entry_value_id = p_cal_entry_value_id
100: and env.calendar_entry_id = ent.calendar_entry_id
101: and pbg.business_group_id (+) = ent.business_group_id;
239: --
240: --
241: CURSOR CSR_ENTRY IS
242: SELECT 'X'
243: FROM per_calendar_entries ent
244: WHERE ent.calendar_entry_id = p_calendar_entry_id;
245: --
246: Begin
247: --
299: -- Get the gen hier id for the entry record,
300: -- which cannot have VS id set
301: CURSOR CSR_ENTRY IS
302: SELECT ent.hierarchy_id
303: FROM per_calendar_entries ent
304: WHERE ent.calendar_entry_id = p_calendar_entry_id
305: AND ent.value_set_id is NULL;
306:
307: -- Check the node exists in the hierarchy version 1
411: -- Get the VS id for the entry record,
412: -- which cannot have a gen hier id set
413: CURSOR CSR_ENTRY IS
414: SELECT ent.VALUE_SET_ID
415: FROM per_calendar_entries ent
416: WHERE ent.calendar_entry_id = p_calendar_entry_id
417: AND ent.hierarchy_id is NULL;
418: --
419: Begin
524: ,p_override_type IN VARCHAR2
525: ,p_effective_date IN DATE) IS
526: --
527: CURSOR csr_OVR IS
528: SELECT name, type from per_calendar_entries
529: WHERE calendar_entry_id = p_calendar_entry_id;
530: --
531: l_proc varchar2(80) := g_package||'chk_override_name_type';
532: l_type per_cal_entry_values.override_type%type;