DBA Data[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on HXT_HDP_DET_HOURS_WORKED_V

Line 3212: hxt_hdp_det_hours_worked_v dhw

3208: CURSOR hdp_hours_deducted_today
3209: IS
3210: SELECT (NVL (sum_hours, 0) - NVL (det_hours, 0))
3211: FROM hxt_hdp_sum_hours_worked_v shw,
3212: hxt_hdp_det_hours_worked_v dhw
3213: WHERE dhw.det_date = g_date_worked
3214: AND dhw.det_tim_id = g_tim_id
3215: AND shw.sum_date = dhw.det_date
3216: AND shw.sum_tim_id = dhw.det_tim_id;

Line 4084: hxt_hdp_det_hours_worked_v dhw

4080: CURSOR hdp_hours_deducted_today
4081: IS
4082: SELECT (NVL (sum_hours, 0) - NVL (det_hours, 0))
4083: FROM hxt_hdp_sum_hours_worked_v shw,
4084: hxt_hdp_det_hours_worked_v dhw
4085: WHERE dhw.det_date = g_date_worked
4086: AND dhw.det_tim_id = g_tim_id
4087: AND shw.sum_date = dhw.det_date
4088: AND shw.sum_tim_id = dhw.det_tim_id;