APPS.HXC_RETRIEVE_ABSENCES dependencies on PER_ABSENCE_ATTENDANCES

Line 2639: per_absence_attendances per

2635: p_stop_time IN DATE)
2636: IS SELECT /*+ LEADING(hxc) */
2637: time_building_block_id
2638: FROM hxc_abs_co_details hxc,
2639: per_absence_attendances per
2640: WHERE resource_id = p_resource_id
2641: AND start_time = p_start_time
2642: AND TRUNC(stop_time) = TRUNC(p_stop_time)
2643: AND stage IN ( 'PREP-SS','PREP', 'DEP')

Line 2932: FROM per_absence_attendances abs

2928: -- twice from OTL and from HR.
2929: CURSOR get_absences
2930: IS SELECT NVL(date_start,date_projected_start),
2931: NVL(date_end,date_projected_end)
2932: FROM per_absence_attendances abs
2933: WHERE person_id = p_resource_id
2934: AND NVL(date_start,date_projected_start) <= p_stop_time
2935: AND NVL(date_end,date_projected_end) >= p_start_time
2936: AND NOT EXISTS ( SELECT /* INDEX(tc HXC_ABS_CO_DETAILS_FK4) */

Line 3153: l_bal := per_absence_attendances_pkg.get_annual_balance(p_start_time,

3149: IF g_debug
3150: THEN
3151: hr_utility.trace(' l_total for '||i);
3152: END IF;
3153: l_bal := per_absence_attendances_pkg.get_annual_balance(p_start_time,
3154: i,
3155: l_asg);
3156: IF g_debug
3157: THEN

Line 3173: IF NOT per_absence_attendances_pkg.is_emp_entitled (i,

3169: 'ABS&'||get_abs_name(i));
3170: END IF;
3171:
3172:
3173: IF NOT per_absence_attendances_pkg.is_emp_entitled (i,
3174: l_asg,
3175: p_start_time,
3176: l_tottab(i),
3177: l_tottab(i))

Line 3254: l_bal := per_absence_attendances_pkg.get_annual_balance(p_start_time,

3250: IF g_debug
3251: THEN
3252: hr_utility.trace(' l_total for '||i);
3253: END IF;
3254: l_bal := per_absence_attendances_pkg.get_annual_balance(p_start_time,
3255: i,
3256: l_asg);
3257: IF g_debug
3258: THEN

Line 3274: IF NOT per_absence_attendances_pkg.is_emp_entitled (i,

3270: 'ABS&'||get_abs_name(i));
3271: END IF;
3272:
3273:
3274: IF NOT per_absence_attendances_pkg.is_emp_entitled (i,
3275: l_asg,
3276: p_start_time,
3277: l_tottab(i),
3278: l_tottab(i))

Line 3352: l_bal := per_absence_attendances_pkg.get_annual_balance(p_stop_time,

3348: IF g_debug
3349: THEN
3350: hr_utility.trace(' l_total for '||i);
3351: END IF;
3352: l_bal := per_absence_attendances_pkg.get_annual_balance(p_stop_time,
3353: i,
3354: l_asg);
3355: IF g_debug
3356: THEN

Line 3372: IF NOT per_absence_attendances_pkg.is_emp_entitled (i,

3368: 'ABS&'||get_abs_name(i));
3369: END IF;
3370:
3371:
3372: IF NOT per_absence_attendances_pkg.is_emp_entitled (i,
3373: l_asg,
3374: p_stop_time,
3375: l_tottab(i),
3376: l_tottab(i))