APPS.PER_CTR_BUS dependencies on HR_GENERAL

Line 364: and (nvl(date_end,hr_general.end_of_time)

360: select 'Y'
361: from per_contact_relationships
362: where person_id = p_person_id
363: and primary_contact_flag = 'Y'
364: and (nvl(date_end,hr_general.end_of_time)
365: > nvl(p_date_start,hr_general.start_of_time)
366: and nvl(date_start,hr_general.start_of_time)
367: < nvl(p_date_end,hr_general.end_of_time));
368: --

Line 365: > nvl(p_date_start,hr_general.start_of_time)

361: from per_contact_relationships
362: where person_id = p_person_id
363: and primary_contact_flag = 'Y'
364: and (nvl(date_end,hr_general.end_of_time)
365: > nvl(p_date_start,hr_general.start_of_time)
366: and nvl(date_start,hr_general.start_of_time)
367: < nvl(p_date_end,hr_general.end_of_time));
368: --
369: l_exists varchar2(1) := 'N';

Line 366: and nvl(date_start,hr_general.start_of_time)

362: where person_id = p_person_id
363: and primary_contact_flag = 'Y'
364: and (nvl(date_end,hr_general.end_of_time)
365: > nvl(p_date_start,hr_general.start_of_time)
366: and nvl(date_start,hr_general.start_of_time)
367: < nvl(p_date_end,hr_general.end_of_time));
368: --
369: l_exists varchar2(1) := 'N';
370: l_proc varchar2(72) := g_package||'chk_contact_type';

Line 367: < nvl(p_date_end,hr_general.end_of_time));

363: and primary_contact_flag = 'Y'
364: and (nvl(date_end,hr_general.end_of_time)
365: > nvl(p_date_start,hr_general.start_of_time)
366: and nvl(date_start,hr_general.start_of_time)
367: < nvl(p_date_end,hr_general.end_of_time));
368: --
369: l_exists varchar2(1) := 'N';
370: l_proc varchar2(72) := g_package||'chk_contact_type';
371: --

Line 600: -- changed for bug 1995269 p_date_start >= nvl(p_date_end, hr_general.end_of_time) then

596: --
597: hr_utility.set_location('Entering:'|| l_proc,5);
598: --
599: if p_date_start is NOT NULL and
600: -- changed for bug 1995269 p_date_start >= nvl(p_date_end, hr_general.end_of_time) then
601: p_date_start > nvl(p_date_end, hr_general.end_of_time) then
602: hr_utility.set_message(800,'PER_7003_ALL_DATE_FROM_TO');
603: hr_utility.raise_error;
604: end if;

Line 601: p_date_start > nvl(p_date_end, hr_general.end_of_time) then

597: hr_utility.set_location('Entering:'|| l_proc,5);
598: --
599: if p_date_start is NOT NULL and
600: -- changed for bug 1995269 p_date_start >= nvl(p_date_end, hr_general.end_of_time) then
601: p_date_start > nvl(p_date_end, hr_general.end_of_time) then
602: hr_utility.set_message(800,'PER_7003_ALL_DATE_FROM_TO');
603: hr_utility.raise_error;
604: end if;
605: --

Line 658: l_start_of_time date := hr_general.start_of_time;

654: p_date_start DATE,
655: p_date_end DATE,
656: p_object_version_number in number) is
657: l_records varchar2(1);
658: l_start_of_time date := hr_general.start_of_time;
659: l_end_of_time date := hr_general.end_of_time;
660:
661: cursor csr_chk_time_validation is
662: select 'X'

Line 659: l_end_of_time date := hr_general.end_of_time;

655: p_date_end DATE,
656: p_object_version_number in number) is
657: l_records varchar2(1);
658: l_start_of_time date := hr_general.start_of_time;
659: l_end_of_time date := hr_general.end_of_time;
660:
661: cursor csr_chk_time_validation is
662: select 'X'
663: from per_contact_relationships per