APPS.OTA_TDB_BUS dependencies on PER_ALL_PEOPLE_F

Line 451: from per_all_people_f

447: -- cursor to perform check for internal delegates
448: --
449: cursor c_internal is
450: select 1
451: from per_all_people_f
452: where person_id = p_person_id
453: and p_date between effective_start_date and effective_end_date;
454: --
455: --

Line 514: l_full_name per_all_people_f.full_name%TYPE; --Bug 2256328

510: -- ----------------------------------------------------------------------------
511: function get_full_name (p_last_name in varchar2
512: ,p_title in varchar2
513: ,p_first_name in varchar2) return varchar2 is
514: l_full_name per_all_people_f.full_name%TYPE; --Bug 2256328
515: begin
516: if p_last_name is not null then
517: l_full_name := p_last_name||',';
518: if p_title is not null then

Line 542: l_full_name per_all_people_f.full_name%TYPE;

538: ,p_last_name_alt in varchar2
539: ,p_first_name_alt in varchar2
540: ) return varchar2
541: is
542: l_full_name per_all_people_f.full_name%TYPE;
543: begin
544: --
545: if p_legislation_code = 'JP' then
546: --

Line 585: l_full_name per_all_people_f.full_name%TYPE;

581: ,p_last_name_alt in varchar2
582: ,p_first_name_alt in varchar2
583: ) return varchar2
584: is
585: l_full_name per_all_people_f.full_name%TYPE;
586: l_legislation varchar2(30);
587: --
588: cursor cur_leg is
589: select legislation_code

Line 655: per_all_people_f ppf,

651: /* Added the person type 'CWK' and removed 'EMP_APL' -- Enh No 2530860 */
652: CURSOR c_student_rehire IS
653: SELECT paf.ROWID
654: FROM per_all_assignments_f paf, ota_events evt ,
655: per_all_people_f ppf,
656: per_person_type_usages_f ptu,
657: per_person_types ppt
658: WHERE paf.person_id = l_person_id
659: AND ppf.person_id = l_person_id

Line 716: per_all_people_f ppf,

712: /* Added the person type 'CWK' and removed 'EMP_APL' */
713: CURSOR c_contact_rehire IS
714: SELECT paf.ROWID
715: FROM per_all_assignments_f paf ,
716: per_all_people_f ppf,
717: per_person_type_usages_f ptu,
718: per_person_types ppt
719: WHERE paf.person_id = l_person_id
720: AND ppf.person_id = l_person_id