DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_ALL_PEOPLE_F

Line 4305: l_rec per_all_people_f%rowtype;

4301: l_inst_set ben_rt_prfl_cache.g_optd_mdcr_inst_tbl;
4302: l_inst_count number;
4303: l_ok boolean := false;
4304: l_rows_found boolean := false;
4305: l_rec per_all_people_f%rowtype;
4306: --
4307: begin
4308: --
4309: hr_utility.set_location('Entering : '||l_proc,10);

Line 4430: l_rec per_all_people_f%rowtype;

4426: l_inst_set ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl;
4427: l_inst_count number;
4428: l_ok boolean := false;
4429: l_rows_found boolean := false;
4430: l_rec per_all_people_f%rowtype;
4431: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
4432: --
4433: cursor c1(p_person_id in number
4434: ,p_lf_evt_ocrd_dt in date

Line 6169: l_rec per_all_people_f%rowtype;

6165: l_inst_count number;
6166: l_ok boolean := false;
6167: l_rows_found boolean := false;
6168: l_dummy varchar2(1);
6169: l_rec per_all_people_f%rowtype;
6170: --
6171:
6172:
6173: begin

Line 6226: l_rec per_all_people_f%rowtype;

6222: l_inst_count number;
6223: l_ok boolean := false;
6224: l_rows_found boolean := false;
6225: l_dummy varchar2(1);
6226: l_rec per_all_people_f%rowtype;
6227: --
6228:
6229:
6230: begin

Line 7183: ,p_per_row in per_all_people_F%rowtype

7179: -- ---------------------------------------------------------------------------
7180: procedure main
7181: (p_currepe_row in ben_determine_rates.g_curr_epe_rec
7182: := ben_determine_rates.g_def_curr_epe_rec
7183: ,p_per_row in per_all_people_F%rowtype
7184: := ben_determine_rates.g_def_curr_per_rec
7185: ,p_asg_row in per_all_assignments_f%rowtype
7186: := ben_determine_rates.g_def_curr_asg_rec
7187: ,p_ast_row in per_assignment_status_types%rowtype

Line 7250: l_per_rec per_all_people_f%rowtype;

7246: l_vrbl_rt_prfl_id ben_vrbl_rt_prfl_f.vrbl_rt_prfl_id%type := NULL;
7247: l_oipl_rec ben_oipl_f%rowtype;
7248: l_gre_id number(15);
7249: l_person_type varchar2(30);
7250: l_per_rec per_all_people_f%rowtype;
7251: l_asg_rec per_all_assignments_f%rowtype;
7252: l_adr_rec per_addresses%rowtype;
7253: l_loc_rec hr_locations_all%rowtype;
7254: l_jurisdiction_code varchar2(30);