APPS.GHR_CORR_CANC_SF52 dependencies on PER_PEOPLE_F

Line 873: from per_people_f

869: cursor c_bg ( c_person_id number,
870: c_as_on_date date) is
871: select
872: business_group_id
873: from per_people_f
874: where person_id = c_person_id and
875: c_as_on_date between effective_start_date and effective_end_date;
876:
877: -- this cursor gets the ghr_pa_history rows (with the rowid included) for the person_id specified and locks

Line 4056: -- This procedure deletes a row from per_people_f table.

4052: -- ---------------------------------------------------------------------------
4053: -- {Start Of Comments}
4054: --
4055: -- Description:
4056: -- This procedure deletes a row from per_people_f table.
4057: --
4058: -- Pre-Requisities:
4059: -- None.
4060: --

Line 4067: -- per_people_f row will have been deleted.

4063: -- p_dt_mode -> datetrack delete mode.
4064: -- p_date_effective -> effective date of delete.
4065: --
4066: -- Post Success:
4067: -- per_people_f row will have been deleted.
4068: --
4069: -- Post Failure:
4070: -- message will have been displayed to user explaining why the delete could not be completed.
4071: --

Line 4084: l_proc varchar2(72) := 'delete_per_people_f_row';

4080:
4081: PROCEDURE delete_peop_row( p_person_id in varchar2,
4082: p_dt_mode in varchar2,
4083: p_date_effective in date) IS
4084: l_proc varchar2(72) := 'delete_per_people_f_row';
4085: l_ovn number;
4086: l_effective_start_date date;
4087: l_effective_end_date date;
4088: cursor c_get_ovn (cp_person_id in number,

Line 4091: FROM PER_PEOPLE_F

4087: l_effective_end_date date;
4088: cursor c_get_ovn (cp_person_id in number,
4089: cp_date_effective in date) is
4090: SELECT object_version_number
4091: FROM PER_PEOPLE_F
4092: WHERE person_id = cp_person_id
4093: AND cp_date_effective between effective_start_date and effective_end_date;
4094: BEGIN
4095: hr_utility.set_location( 'Entering : ' || l_proc, 10);

Line 4241: -- This procedure deletes a row from per_people_f table.

4237: -- ---------------------------------------------------------------------------
4238: -- {Start Of Comments}
4239: --
4240: -- Description:
4241: -- This procedure deletes a row from per_people_f table.
4242: --
4243: -- Pre-Requisities:
4244: -- None.
4245: --