APPS.GHR_CORR_CANC_SF52 dependencies on PER_ALL_PEOPLE_F

Line 2425: l_people_data per_all_people_f%rowtype;

2421: from ghr_pa_request_shadow
2422: where pa_request_id = c_pa_request_id;
2423:
2424: l_proc varchar2(30):='correction_sf52';
2425: l_people_data per_all_people_f%rowtype;
2426:
2427: Procedure Refresh_Cascade_Name( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
2428: p_shadow_rec in out nocopy ghr_pa_request_shadow%rowtype) is
2429:

Line 2431: l_people_data per_all_people_f%rowtype;

2427: Procedure Refresh_Cascade_Name( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
2428: p_shadow_rec in out nocopy ghr_pa_request_shadow%rowtype) is
2429:
2430: l_result_code varchar2(30);
2431: l_people_data per_all_people_f%rowtype;
2432: l_hist_id number;
2433: l_proc varchar2(40):='Refresh_Cascade_Name';
2434: l_capped_other_pay number := hr_api.g_number;
2435:

Line 5948: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,

5944: and first_noa_code = '001'
5945: and second_noa_code = par.first_noa_code);
5946:
5947:
5948: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
5949: c_effective_date per_all_people_f.effective_start_date%type)
5950: is
5951: select business_group_id bg_id
5952: from per_all_people_f

Line 5949: c_effective_date per_all_people_f.effective_start_date%type)

5945: and second_noa_code = par.first_noa_code);
5946:
5947:
5948: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
5949: c_effective_date per_all_people_f.effective_start_date%type)
5950: is
5951: select business_group_id bg_id
5952: from per_all_people_f
5953: where person_id = c_person_id

Line 5952: from per_all_people_f

5948: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
5949: c_effective_date per_all_people_f.effective_start_date%type)
5950: is
5951: select business_group_id bg_id
5952: from per_all_people_f
5953: where person_id = c_person_id
5954: and c_effective_date between effective_start_date
5955: and effective_end_date;
5956:

Line 5967: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,

5963: where pgm.name = c_prog_name
5964: and pgm.business_group_id = c_business_group_id
5965: and c_effective_date between effective_start_date and effective_end_date;
5966:
5967: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,
5968: p_pgm_id ben_pgm_f.pgm_id%type,
5969: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,
5970: p_effective_date date)
5971: is