APPS.PQP_ABSVAL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 2110: per_absence_attendances.absence_attendance_id%TYPE

2106: IS
2107: --
2108: CURSOR csr_absence_part_days
2109: (p_absence_attendance_id IN
2110: per_absence_attendances.absence_attendance_id%TYPE
2111: )
2112: IS
2113: SELECT abs_information1 -- fraction of start day
2114: ,abs_information2 -- fraction of end day

Line 2116: FROM per_absence_attendances

2112: IS
2113: SELECT abs_information1 -- fraction of start day
2114: ,abs_information2 -- fraction of end day
2115: ,abs_information3 -- UOM of the fraction
2116: FROM per_absence_attendances
2117: WHERE abs_information_category = 'GB_PQP_OSP_OMP_PART_DAYS'
2118: AND absence_attendance_id = p_absence_attendance_id;
2119:
2120:

Line 2449: ,per_absence_attendances abs

2445: ,'NC',abs.date_end+1
2446: ,'FC',abs.date_start
2447: )
2448: FROM pqp_gap_absence_plans gap
2449: ,per_absence_attendances abs
2450: ,ben_pl_f pln
2451: WHERE gap.assignment_id = p_assignment_id --an absence for this assignment
2452: AND pln.pl_typ_id = p_pl_typ_id --which is relevant, ie enrolled
2453: AND gap.pl_id = pln.pl_id --into a plan of atleast the same

Line 3492: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;

3488: IS
3489:
3490: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
3491: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
3492: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
3493:
3494: l_duration NUMBER ;
3495: l_duration_to_process NUMBER ;
3496: l_duration_processed NUMBER ;

Line 4934: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;

4930: 'update_absence_plan_details';
4931: l_open_ended_no_pay_days NUMBER;
4932: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
4933: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
4934: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
4935: BEGIN
4936:
4937:
4938: g_debug := hr_utility.debug_enabled;