APPS.PQP_ABSVAL_PKG dependencies on PER_ABSENCE_ATTENDANCES

Line 2089: per_absence_attendances.absence_attendance_id%TYPE

2085: IS
2086: --
2087: CURSOR csr_absence_part_days
2088: (p_absence_attendance_id IN
2089: per_absence_attendances.absence_attendance_id%TYPE
2090: )
2091: IS
2092: SELECT abs_information1 -- fraction of start day
2093: ,abs_information2 -- fraction of end day

Line 2095: FROM per_absence_attendances

2091: IS
2092: SELECT abs_information1 -- fraction of start day
2093: ,abs_information2 -- fraction of end day
2094: ,abs_information3 -- UOM of the fraction
2095: FROM per_absence_attendances
2096: WHERE abs_information_category = 'GB_PQP_OSP_OMP_PART_DAYS'
2097: AND absence_attendance_id = p_absence_attendance_id;
2098:
2099:

Line 2428: ,per_absence_attendances abs

2424: ,'NC',abs.date_end+1
2425: ,'FC',abs.date_start
2426: )
2427: FROM pqp_gap_absence_plans gap
2428: ,per_absence_attendances abs
2429: ,ben_pl_f pln
2430: WHERE gap.assignment_id = p_assignment_id --an absence for this assignment
2431: AND pln.pl_typ_id = p_pl_typ_id --which is relevant, ie enrolled
2432: AND gap.pl_id = pln.pl_id --into a plan of atleast the same

Line 3471: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;

3467: IS
3468:
3469: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
3470: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
3471: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
3472:
3473: l_duration NUMBER ;
3474: l_duration_to_process NUMBER ;
3475: l_duration_processed NUMBER ;

Line 4906: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;

4902: 'update_absence_plan_details';
4903: l_open_ended_no_pay_days NUMBER;
4904: l_part_start_day pqp_gap_daily_absences.duration%TYPE;
4905: l_part_end_day pqp_gap_daily_absences.duration%TYPE;
4906: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
4907: BEGIN
4908:
4909:
4910: g_debug := hr_utility.debug_enabled;