DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_ALL_PEOPLE_F

Line 4252: l_rec per_all_people_f%rowtype;

4248: l_inst_set ben_rt_prfl_cache.g_optd_mdcr_inst_tbl;
4249: l_inst_count number;
4250: l_ok boolean := false;
4251: l_rows_found boolean := false;
4252: l_rec per_all_people_f%rowtype;
4253: --
4254: begin
4255: --
4256: hr_utility.set_location('Entering : '||l_proc,10);

Line 4377: l_rec per_all_people_f%rowtype;

4373: l_inst_set ben_rt_prfl_cache.g_cbr_qual_bnf_inst_tbl;
4374: l_inst_count number;
4375: l_ok boolean := false;
4376: l_rows_found boolean := false;
4377: l_rec per_all_people_f%rowtype;
4378: l_quald_bnf_flag ben_cbr_quald_bnf.quald_bnf_flag%type;
4379: --
4380: cursor c1(p_person_id in number
4381: ,p_lf_evt_ocrd_dt in date

Line 6112: l_rec per_all_people_f%rowtype;

6108: l_inst_count number;
6109: l_ok boolean := false;
6110: l_rows_found boolean := false;
6111: l_dummy varchar2(1);
6112: l_rec per_all_people_f%rowtype;
6113: --
6114:
6115:
6116: begin

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 7126: ,p_per_row in per_all_people_F%rowtype

7122: -- ---------------------------------------------------------------------------
7123: procedure main
7124: (p_currepe_row in ben_determine_rates.g_curr_epe_rec
7125: := ben_determine_rates.g_def_curr_epe_rec
7126: ,p_per_row in per_all_people_F%rowtype
7127: := ben_determine_rates.g_def_curr_per_rec
7128: ,p_asg_row in per_all_assignments_f%rowtype
7129: := ben_determine_rates.g_def_curr_asg_rec
7130: ,p_ast_row in per_assignment_status_types%rowtype

Line 7193: l_per_rec per_all_people_f%rowtype;

7189: l_vrbl_rt_prfl_id ben_vrbl_rt_prfl_f.vrbl_rt_prfl_id%type := NULL;
7190: l_oipl_rec ben_oipl_f%rowtype;
7191: l_gre_id number(15);
7192: l_person_type varchar2(30);
7193: l_per_rec per_all_people_f%rowtype;
7194: l_asg_rec per_all_assignments_f%rowtype;
7195: l_adr_rec per_addresses%rowtype;
7196: l_loc_rec hr_locations_all%rowtype;
7197: l_jurisdiction_code varchar2(30);