DBA Data[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on HXT_HDP_DET_HOURS_WORKED_V

Line 2137: hxt_hdp_det_hours_worked_v dhw

2133: CURSOR hdp_hours_deducted_today
2134: IS
2135: SELECT (NVL (sum_hours, 0) - NVL (det_hours, 0))
2136: FROM hxt_hdp_sum_hours_worked_v shw,
2137: hxt_hdp_det_hours_worked_v dhw
2138: WHERE dhw.det_date = g_date_worked
2139: AND dhw.det_tim_id = g_tim_id
2140: AND shw.sum_date = dhw.det_date
2141: AND shw.sum_tim_id = dhw.det_tim_id;

Line 2894: hxt_hdp_det_hours_worked_v dhw

2890: CURSOR hdp_hours_deducted_today
2891: IS
2892: SELECT (NVL (sum_hours, 0) - NVL (det_hours, 0))
2893: FROM hxt_hdp_sum_hours_worked_v shw,
2894: hxt_hdp_det_hours_worked_v dhw
2895: WHERE dhw.det_date = g_date_worked
2896: AND dhw.det_tim_id = g_tim_id
2897: AND shw.sum_date = dhw.det_date
2898: AND shw.sum_tim_id = dhw.det_tim_id;