[Home] [Help]
10:
11: g_default_start_day VARCHAR2(30):=
12: pqp_schedule_calculation_pkg.g_default_start_day;
13:
14: g_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
15: g_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
16: g_balance_date DATE := hr_api.g_date;
17: g_absences_taken_to_date pqp_absval_pkg.t_entitlements;
18:
21: g_scheme_calendar_uom pay_element_type_extra_info.eei_information1%TYPE;
22: g_scheme_start_date_txt VARCHAR2(80);
23:
24: -- Cache for get_omp_band_ent_bal_pl_typ
25: g_omp_assignment_id per_all_assignments_f.assignment_id%TYPE := 0;
26: g_omp_pl_typ_id ben_pl_f.pl_id%TYPE := 0;
27: g_omp_balance_date DATE := hr_api.g_date;
28: g_omp_absences_taken_to_date pqp_absval_pkg.t_entitlements;
29:
179: --l_null_per_pattern c_per_pattern%ROWTYPE;
180: --l_null_pattern c_pattern%ROWTYPE;
181: BEGIN
182:
183: g_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
184: g_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
185: g_balance_date := NULL;--DATE := hr_api.g_date
186: g_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
187:
190: g_scheme_calendar_uom := NULL ;
191: g_scheme_start_date_txt := NULL ;
192:
193: -- Cache for get_omp_band_ent_bal_pl_typ
194: g_omp_assignment_id := NULL;--per_all_assignments_f.assignment_id%TYPE := 0
195: g_omp_pl_typ_id := NULL;--ben_pl_f.pl_id%TYPE := 0
196: g_omp_balance_date := NULL;--DATE := hr_api.g_date
197: g_omp_absences_taken_to_date.DELETE; --pqp_absval_pkg.t_entitlements
198:
2157: ,pei_information11 band1
2158: ,pei_information12 band2
2159: ,pei_information13 band3
2160: ,pei_information14 band4
2161: FROM per_all_assignments_f asg
2162: ,per_people_extra_info pei
2163: WHERE asg.assignment_id = p_assignment_id -- index primary key
2164: AND p_effective_date
2165: BETWEEN asg.effective_start_date
8742: l_ssp_retro_input_values g_ssp_retro_input_values%TYPE;
8743: l_ssp_retro_element_links g_ssp_retro_element_links%TYPE;
8744:
8745: l_max_ssp_period NUMBER;
8746: l_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
8747: l_absence csr_absence_details%ROWTYPE;
8748: l_piw_id per_absence_attendances.absence_attendance_id%TYPE;
8749: i BINARY_INTEGER:= 0;
8750: j BINARY_INTEGER:= 0;
9536: l_range_amount NUMBER:=0;
9537: l_absence_amount NUMBER:=0;
9538:
9539: l_absence csr_absence_details%ROWTYPE;
9540: l_primary_assignment_id per_all_assignments_f.assignment_id%TYPE;
9541:
9542: c_smp_element_name CONSTANT
9543: pay_element_types_f.element_name%TYPE:='Statutory Maternity Pay';
9544: c_sap_element_name CONSTANT
10933: IS
10934: SELECT atd.abs_information4 start_date_txt -- minimum pay start day
10935: ,atd.abs_information5 end_date_txt -- minimum pay end day
10936: ,atd.abs_information6 min_pay -- minimum pay value
10937: FROM per_absence_attendances atd, per_all_assignments_f asg
10938: WHERE atd.abs_information_category = 'GB_PQP_OSP_OMP_PART_DAYS'
10939: AND atd.absence_attendance_id = p_absence_id
10940: AND atd.person_id = asg.person_id
10941: AND asg.assignment_id = p_assignment_id
11249: AND abs.business_group_id = p_business_group_id ;
11250:
11251: CURSOR csr_assignment_person IS
11252: SELECT asg.person_id
11253: FROM per_all_assignments_f asg
11254: WHERE asg.assignment_id = p_assignment_id
11255: AND rownum < 2 ;
11256:
11257: l_abs_person_id per_absence_attendances.person_id%TYPE ;
11254: WHERE asg.assignment_id = p_assignment_id
11255: AND rownum < 2 ;
11256:
11257: l_abs_person_id per_absence_attendances.person_id%TYPE ;
11258: l_asg_person_id per_all_assignments_f.person_id%TYPE ;
11259:
11260: BEGIN
11261:
11262: IF g_debug THEN
12183: where a3.person_id = b3.person_id and a3.person_id = l_person_id
12184: and c_date between date_from and least(nvl(date_end, date_to), date_to );
12185:
12186: CURSOR cur_person_id is
12187: SELECT person_id FROM per_all_assignments_f WHERE assignment_id = p_assignment_id;
12188:
12189: BEGIN
12190: IF g_debug THEN
12191: debug_enter(l_proc_name);