APPS.IRC_COMMUNICATIONS_API dependencies on PER_ALL_PEOPLE_F

Line 1533: Cursor cur_ppf(p_person_id per_all_people_f.person_id%TYPE) is

1529: where
1530: icr.communication_recipient_id = p_recipient_id
1531: and icr.communication_object_type = 'TOPIC';
1532: --
1533: Cursor cur_ppf(p_person_id per_all_people_f.person_id%TYPE) is
1534: --get person full name
1535: select ppf.full_name
1536: from per_all_people_f ppf
1537: where

Line 1536: from per_all_people_f ppf

1532: --
1533: Cursor cur_ppf(p_person_id per_all_people_f.person_id%TYPE) is
1534: --get person full name
1535: select ppf.full_name
1536: from per_all_people_f ppf
1537: where
1538: ppf.person_id = p_person_id
1539: and trunc(sysdate) between Effective_start_date and Effective_end_date;
1540: --

Line 1558: l_full_name per_all_people_f.full_name%TYPE;

1554: l_rec_id number;
1555: l_mgr_id number;
1556: l_apl_id number;
1557: l_team_id number;
1558: l_full_name per_all_people_f.full_name%TYPE;
1559: l_meaning_rec hr_lookups.meaning%TYPE;
1560: l_meaning_mgr hr_lookups.meaning%TYPE;
1561: l_meaning_apl hr_lookups.meaning%TYPE;
1562: l_meaning_tm hr_lookups.meaning%TYPE;