DBA Data[Home] [Help]

APPS.PER_PL_PERSON_EXTRA_INFO dependencies on PER_PEOPLE_EXTRA_INFO

Line 50: select 1 from per_people_extra_info where

46: P_FLEX_END_DATE VARCHAR2,
47: P_INFORMATION_TYPE VARCHAR2) IS
48:
49: cursor csr_overlap_rec is
50: select 1 from per_people_extra_info where
51: person_id = P_PERSON_ID and
52: information_type = P_INFORMATION_TYPE and
53: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(PEI_INFORMATION1)
54: and nvl(fnd_date.canonical_to_date(PEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or

Line 116: select 1 from per_people_extra_info where

112:
113: -- This cursor checks if the Start/End Dates are not overlapping with other records
114:
115: cursor csr_overlap_upd_rec is
116: select 1 from per_people_extra_info where
117: pei_information_category = P_PEI_INFORMATION_CATEGORY and
118: (fnd_date.canonical_to_date(P_FLEX_START_DATE) between fnd_date.canonical_to_date(PEI_INFORMATION1)
119: and nvl(fnd_date.canonical_to_date(PEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) or
120: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))

Line 128: person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID) and

124: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) or
125: nvl(fnd_date.canonical_to_date(PEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
126: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
127: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))) and
128: person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID) and
129: person_extra_info_id <> P_PERSON_EXTRA_INFO_ID;
130:
131:
132:

Line 138: where pap.person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID) and

134:
135: cursor csr_chk_contact_date is
136: select 1 from
137: per_people_f pap,per_person_types ppf,per_person_type_usages_f ptu
138: where pap.person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID) and
139: pap.person_id = ptu.person_id and
140: ppf.person_type_id = ptu.person_type_id and
141: ppf.SEEDED_PERSON_TYPE_KEY = 'CONTACT' and
142: pap.effective_start_date <= fnd_date.canonical_to_date(P_FLEX_START_DATE) and

Line 148: person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID)

144: ptu.effective_start_date <= fnd_date.canonical_to_date(P_FLEX_START_DATE) and
145: ptu.effective_end_date >= nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'));
146:
147: cursor cur_inherit is select per_information2 from per_all_people_f where
148: person_id in (select person_id from per_people_extra_info where person_extra_info_id = P_PERSON_EXTRA_INFO_ID)
149: and effective_start_date <= fnd_date.canonical_to_date(P_FLEX_START_DATE)
150: and effective_end_date >= nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
151: and per_information2 ='Y';
152: