APPS.PER_NEW_HIRE_PKG dependencies on PER_ALL_PEOPLE_F

Line 5102: per_all_people_f ppf, --table

5098: job.name,
5099: ppf.work_telephone
5100: From
5101: --per_people_f ppf, --view bug 4912696
5102: per_all_people_f ppf, --table
5103: --per_assignments_f paf, --view bug 4912696
5104: per_all_assignments_f paf, --table
5105: per_jobs job
5106: Where

Line 5119: from per_all_people_f ppf1 --table bug 4912696

5115: and paf.effective_end_date
5116: -- BUG2919553
5117: And ppf.effective_start_date =
5118: (select max(ppf1.effective_start_date)
5119: from per_all_people_f ppf1 --table bug 4912696
5120: where ppf1.person_id = ppf.person_id
5121: and ppf1.effective_start_date <= p_report_date
5122: )
5123: -- End of BUG2919553

Line 5171: lv_contact_first_name per_all_people_f.first_name%TYPE;

5167: p_contact_last_name out nocopy varchar2
5168: ) IS
5169: --
5170: l_api_name varchar2(61) := g_package_name || '.get_new_hire_contact_name';
5171: lv_contact_first_name per_all_people_f.first_name%TYPE;
5172: lv_contact_last_name per_all_people_f.last_name%TYPE;
5173:
5174: CURSOR c_new_hire_record IS
5175: Select ppf.first_name

Line 5172: lv_contact_last_name per_all_people_f.last_name%TYPE;

5168: ) IS
5169: --
5170: l_api_name varchar2(61) := g_package_name || '.get_new_hire_contact_name';
5171: lv_contact_first_name per_all_people_f.first_name%TYPE;
5172: lv_contact_last_name per_all_people_f.last_name%TYPE;
5173:
5174: CURSOR c_new_hire_record IS
5175: Select ppf.first_name
5176: , ppf.last_name

Line 5177: From per_all_people_f ppf

5173:
5174: CURSOR c_new_hire_record IS
5175: Select ppf.first_name
5176: , ppf.last_name
5177: From per_all_people_f ppf
5178: Where ppf.person_id = p_person_id
5179: And ppf.business_group_id + 0 = p_business_group_id
5180: And ppf.effective_start_date =
5181: (select max(ppf1.effective_start_date)

Line 5182: from per_all_people_f ppf1

5178: Where ppf.person_id = p_person_id
5179: And ppf.business_group_id + 0 = p_business_group_id
5180: And ppf.effective_start_date =
5181: (select max(ppf1.effective_start_date)
5182: from per_all_people_f ppf1
5183: where ppf1.person_id = ppf.person_id
5184: and ppf1.effective_start_date <= p_report_date
5185: );
5186: --

Line 5222: l_new_string per_all_people_f.FIRST_NAME%TYPE;

5218: function remove_special_characters(p_string IN varchar2,
5219: p_allowed IN varchar2 default NULL)
5220: return varchar2
5221: IS
5222: l_new_string per_all_people_f.FIRST_NAME%TYPE;
5223: l_not_allowed VARCHAR2(100) := '''`;"|\-+=_#$%^&*@!~:<>?/()[]{},.';
5224: BEGIN
5225:
5226: if instr(p_allowed,'`') <> 0 then