APPS.GHR_CORR_CANC_SF52 dependencies on PER_ALL_PEOPLE_F

Line 2686: l_people_data per_all_people_f%rowtype;

2682: from ghr_pa_request_shadow
2683: where pa_request_id = c_pa_request_id;
2684:
2685: l_proc varchar2(30):='correction_sf52';
2686: l_people_data per_all_people_f%rowtype;
2687:
2688: --6850492
2689: cursor chk_dual_action(c_pa_request_id in number)
2690: is

Line 2711: l_people_data per_all_people_f%rowtype;

2707: Procedure Refresh_Cascade_Name( p_sf52_rec in out nocopy ghr_pa_requests%rowtype,
2708: p_shadow_rec in out nocopy ghr_pa_request_shadow%rowtype) is
2709:
2710: l_result_code varchar2(30);
2711: l_people_data per_all_people_f%rowtype;
2712: l_hist_id number;
2713: l_proc varchar2(40):='Refresh_Cascade_Name';
2714: l_capped_other_pay number := hr_api.g_number;
2715:

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

6297: and first_noa_code = '001'
6298: and second_noa_code = par.first_noa_code);
6299:
6300:
6301: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
6302: c_effective_date per_all_people_f.effective_start_date%type)
6303: is
6304: select business_group_id bg_id
6305: from per_all_people_f

Line 6302: c_effective_date per_all_people_f.effective_start_date%type)

6298: and second_noa_code = par.first_noa_code);
6299:
6300:
6301: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
6302: c_effective_date per_all_people_f.effective_start_date%type)
6303: is
6304: select business_group_id bg_id
6305: from per_all_people_f
6306: where person_id = c_person_id

Line 6305: from per_all_people_f

6301: Cursor c_bg_id(c_person_id per_all_people_f.person_id%type,
6302: c_effective_date per_all_people_f.effective_start_date%type)
6303: is
6304: select business_group_id bg_id
6305: from per_all_people_f
6306: where person_id = c_person_id
6307: and c_effective_date between effective_start_date
6308: and effective_end_date;
6309:

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

6316: where pgm.name = c_prog_name
6317: and pgm.business_group_id = c_business_group_id
6318: and c_effective_date between effective_start_date and effective_end_date;
6319:
6320: Cursor c_get_enrt_rslt(p_person_id per_all_people_f.person_id%type,
6321: p_pgm_id ben_pgm_f.pgm_id%type,
6322: p_per_in_ler_id ben_per_in_ler.per_in_ler_id%type,
6323: p_effective_date date)
6324: is