eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PL_PERSON_EXTRA_INFO dependencies on PER_ALL_PEOPLE_F

Line 64: cursor cur_inherit is select per_information2 from per_all_people_f where person_id =P_PERSON_ID

60: nvl(fnd_date.canonical_to_date(PEI_INFORMATION2),to_date('31/12/4712','DD/MM/YYYY')) between
61: fnd_date.canonical_to_date(P_FLEX_START_DATE) and
62: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')));
63:
64: cursor cur_inherit is select per_information2 from per_all_people_f where person_id =P_PERSON_ID
65: and effective_start_date <= fnd_date.canonical_to_date(P_FLEX_START_DATE)
66: and effective_end_date >= nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
67: and per_information2 ='Y';
68:

Line 70: vInherit per_all_people_f.per_information2%type;

66: and effective_end_date >= nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))
67: and per_information2 ='Y';
68:
69: overlap_found number;
70: vInherit per_all_people_f.per_information2%type;
71: BEGIN
72:
73: if (fnd_date.canonical_to_date(P_FLEX_START_DATE) >
74: nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY'))) then

Line 147: cursor cur_inherit is select per_information2 from per_all_people_f where

143: pap.effective_end_date >= nvl(fnd_date.canonical_to_date(P_FLEX_END_DATE),to_date('31/12/4712','DD/MM/YYYY')) and
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';

Line 153: vInherit per_all_people_f.per_information2%type;

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:
153: vInherit per_all_people_f.per_information2%type;
154:
155: overlap_upd_found number;
156: valid_contact_dates number;
157: