APPS.PER_PL_LEI_INFO dependencies on HR_LOCATION_EXTRA_INFO

Line 28: from hr_location_extra_info where

24: P_INFORMATION_TYPE VARCHAR2) IS
25:
26: cursor csr_overlap_rec is
27: select 1
28: from hr_location_extra_info where
29: location_id = p_location_id and
30: INFORMATION_TYPE = P_INFORMATION_TYPE and
31: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)
32: and nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

Line 84: from hr_location_extra_info where

80:
81:
82: cursor csr_overlap_upd_rec is
83: select 1
84: from hr_location_extra_info where
85: INFORMATION_TYPE = p_lei_information_category
86: and location_extra_info_id <> P_LOCATION_EXTRA_INFO_ID and
87: location_id = (select location_id from hr_location_extra_info where LOCATION_EXTRA_INFO_ID = P_LOCATION_EXTRA_INFO_ID)
88: and (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)

Line 87: location_id = (select location_id from hr_location_extra_info where LOCATION_EXTRA_INFO_ID = P_LOCATION_EXTRA_INFO_ID)

83: select 1
84: from hr_location_extra_info where
85: INFORMATION_TYPE = p_lei_information_category
86: and location_extra_info_id <> P_LOCATION_EXTRA_INFO_ID and
87: location_id = (select location_id from hr_location_extra_info where LOCATION_EXTRA_INFO_ID = P_LOCATION_EXTRA_INFO_ID)
88: and (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(LEI_INFORMATION1)
89: and nvl(fnd_date.canonical_to_date(LEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
90: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
91: between fnd_date.canonical_to_date(LEI_INFORMATION1)