DBA Data[Home] [Help]

APPS.OTA_GENERAL dependencies on PER_ALL_PEOPLE_F

Line 23: per_all_people_f

19: VALID_VENDOR,
20: VALID_CURRENCY
21: 07 Mar 95 J Rhodes Include correct messages
22: 24 Jul 95 J Rhodes Changed per_people_f to
23: per_all_people_f
24: 23 Aug 95 J Rhodes Dummy cursor get_default_values
25: 31 Aug 95 J Rhodes Added check_fnd_user
26: 31 Aug 95 J Rhodes Added get_fnd_user
27: 16 Feb 96 G Perry Added get_session_date

Line 167: from per_all_people_f ppf,

163: -- cursor to check if the person has current employee flag set
164: --
165: Cursor c_current_employee is
166: select 'X'
167: from per_all_people_f ppf,
168: per_person_type_usages_f ptu,
169: per_person_types ppt
170: where p_date between ptu.effective_start_date and ptu.effective_end_date
171: and p_date between ppf.effective_start_date and ppf.effective_end_date

Line 551: from per_all_people_f

547: --
548: Cursor c_person (l_date IN DATE) is -- **** l_date added to cursor definition for bug #2154926
549: -- **** l_date added to where clause for bug #2154926
550: select 'X'
551: from per_all_people_f
552: where person_id = p_person_id
553: and l_date between effective_start_date and effective_end_date;
554: --
555: l_dummy varchar2(1);