APPS.GHR_HISTORY_CASCADE dependencies on PER_ALL_PEOPLE_F

Line 54: p_people_data in out nocopy per_all_people_f%rowtype);

50: Procedure Cascade_addresses (
51: p_post_record in ghr_pa_history%rowtype );
52:
53: Procedure correct_people_row (
54: p_people_data in out nocopy per_all_people_f%rowtype);
55:
56: Procedure correct_asgn_row (
57: p_asgn_data in out nocopy per_all_assignments_f%rowtype);
58:

Line 882: l_people_data per_all_people_f%rowtype;

878: p_hist_data_as_of_date in ghr_pa_history%rowtype
879: ) is
880:
881: l_true_false ghr_history_cascade.condition_rg_type;
882: l_people_data per_all_people_f%rowtype;
883: l_hist_peop_data ghr_pa_history%rowtype;
884: l_stop Boolean;
885: l_proc varchar2(30):='Cascade_People';
886:

Line 890: from per_all_people_f

886:
887: -- this cursor is meant to retrieve all following records in per_people_f table.
888: Cursor c_people( c_date_Effective in date, c_person_id in number) is
889: Select *
890: from per_all_people_f
891: where effective_start_date >= c_date_effective and
892: person_id = c_person_id;
893:
894: Begin

Line 1743: Procedure Correct_people_row (p_people_data in out nocopy per_all_people_f%rowtype) is

1739: --
1740: -- {End Of Comments}
1741: -- ---------------------------------------------------------------------------
1742: -- Procedure Correct_people_row will update the Per_People_F row in correct mode
1743: Procedure Correct_people_row (p_people_data in out nocopy per_all_people_f%rowtype) is
1744:
1745: -- this cursor gets the object_version_number from core table, so the core
1746: -- table can be updated.
1747: cursor c_people_getovn( cp_person_id number,

Line 1751: from per_all_people_f

1747: cursor c_people_getovn( cp_person_id number,
1748: cp_eff_st_dt date
1749: ,cp_eff_end_dt date) is
1750: select object_version_number
1751: from per_all_people_f
1752: where person_id = cp_person_id
1753: and effective_start_date = cp_eff_st_dt;
1754:
1755: -- and effective_end_date = cp_eff_end_dt;

Line 1761: l_people_data per_all_people_f%rowtype;

1757: l_datetrack_mode varchar2(30):=hr_api.g_correction;
1758: l_dob_null_warning boolean;
1759: l_name_combination_warning boolean;
1760: l_orig_hire_warning boolean;
1761: l_people_data per_all_people_f%rowtype;
1762: l_proc varchar2(30):='Correct_people_Row';
1763: l_date1 per_all_people_f.effective_start_date%type;
1764:
1765: Begin

Line 1763: l_date1 per_all_people_f.effective_start_date%type;

1759: l_name_combination_warning boolean;
1760: l_orig_hire_warning boolean;
1761: l_people_data per_all_people_f%rowtype;
1762: l_proc varchar2(30):='Correct_people_Row';
1763: l_date1 per_all_people_f.effective_start_date%type;
1764:
1765: Begin
1766:
1767: hr_utility.set_location( 'Entering : ' || l_proc, 10);