[Home] [Help]
1329: l_inst_count number;
1330: l_insttorrw_num binary_integer;
1331: l_ok boolean := false;
1332: l_rows_found boolean := false;
1333: l_ass_rec per_all_assignments_f%rowtype;
1334: l_outputs ff_exec.outputs_t;
1335: l_include_flag varchar2(80);
1336: --
1337: begin
2407: c_person_id number,
2408: c_freq_cd varchar2,
2409: c_business_group_id number) is
2410: select sum(normal_hours)
2411: from per_all_assignments_f
2412: where person_id = c_person_id
2413: and c_effective_date between effective_start_date and effective_end_date
2414: and frequency = c_freq_cd
2415: and business_group_id = c_business_group_id;
2418: (c_effective_date date,
2419: c_assignment_id number,
2420: c_business_group_id number) is
2421: select normal_hours, frequency
2422: from per_all_assignments_f
2423: where assignment_id = c_assignment_id
2424: and c_effective_date between effective_start_date and effective_end_date
2425: and business_group_id = c_business_group_id;
2426: --
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
7188: := ben_determine_rates.g_def_curr_ast_rec
7189: ,p_adr_row in per_addresses%rowtype
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);
7255: l_matched_vrbl_prfl varchar2(1) := 'N';