APPS.BEN_WHATIF_ELIG dependencies on PER_ALL_PEOPLE_F

Line 340: l_full_name per_all_people_f.full_name%type; --UTF8 Change Bug 2254683

336: l_per_object_version_number number;
337: l_object_version_number number;
338: l_per_effective_start_date date;
339: l_per_effective_end_date date;
340: l_full_name per_all_people_f.full_name%type; --UTF8 Change Bug 2254683
341: l_per_comment_id number;
342: l_name_combination_warning boolean;
343: l_orig_hire_warning boolean;
344: --

Line 1661: per_person_rec per_all_people_f%rowtype;

1657: ,p_business_group_id in number
1658: ,p_effective_date in date
1659: ) is
1660: --
1661: per_person_rec per_all_people_f%rowtype;
1662: --
1663: cursor c_person is
1664: select * from per_all_people_f
1665: where person_id = p_person_id and

Line 1664: select * from per_all_people_f

1660: --
1661: per_person_rec per_all_people_f%rowtype;
1662: --
1663: cursor c_person is
1664: select * from per_all_people_f
1665: where person_id = p_person_id and
1666: p_effective_date between nvl(effective_start_date, p_effective_date)
1667: and nvl(effective_end_date, p_effective_date);
1668: --

Line 1671: l_full_name per_all_people_f.full_name%type; -- UTF8 Change Bug 2254683

1667: and nvl(effective_end_date, p_effective_date);
1668: --
1669: l_effective_start_date date;
1670: l_effective_end_date date;
1671: l_full_name per_all_people_f.full_name%type; -- UTF8 Change Bug 2254683
1672: l_comment_id number;
1673: l_name_combination_warning boolean;
1674: l_assign_payroll_warning boolean;
1675: l_ORIG_HIRE_WARNING boolean;

Line 1913: p_base_table_name => 'PER_ALL_PEOPLE_F',

1909: --
1910: --
1911: Get_DT_Upd_Mode
1912: (p_effective_date => p_effective_date,
1913: p_base_table_name => 'PER_ALL_PEOPLE_F',
1914: p_base_key_column => 'PERSON_ID',
1915: p_base_key_value => per_person_rec.person_id,
1916: p_mode => l_upd_mode);
1917: --

Line 2554: from per_all_people_f per,

2550: and nvl(effective_end_date, p_effective_date);
2551: --
2552: cursor c_get_per_typ is
2553: select pt.system_person_type, ptu.*
2554: from per_all_people_f per,
2555: per_person_types pt,
2556: per_person_type_usages_f ptu
2557: where per.person_id = p_person_id
2558: and per.person_type_id = pt.person_type_id

Line 4330: from per_all_people_f per,

4326: select paf.ASSIGNMENT_ID,
4327: paf.BUSINESS_GROUP_ID,
4328: paf.effective_start_date,
4329: paf.effective_end_date
4330: from per_all_people_f per,
4331: per_assignments_f paf
4332: where per.person_id = p_person_id
4333: and paf.assignment_type <> 'C'
4334: and p_effective_date

Line 4349: from per_all_people_f per,

4345: l_assign c_assign%rowtype;
4346: --
4347: cursor c_exist_fte is
4348: select pab.ASSIGNMENT_BUDGET_VALUE_ID
4349: from per_all_people_f per,
4350: per_assignments_f paf,
4351: per_assignment_budget_values pab
4352: where per.person_id = p_person_id
4353: and paf.assignment_type <> 'C'