665: hxt_det_hours_worked_f DET
666: WHERE sum.tim_id = :tim_id
667: AND sum.id = det.parent_id
668: AND sum.element_type_id IS NULL
669: AND sum.date_worked = FND_date.CANONICAL_TO_DATE(:date_worked)
670: AND det.element_type_id IN ELEMENT_LIST
671: AND FND_DATE.CANONICAL_TO_DATE(:session_date1) BETWEEN sum.effective_start_date
672: AND sum.effective_end_date
673: AND FND_DATE.CANONICAL_TO_DATE(:session_date2) BETWEEN det.effective_start_date
667: AND sum.id = det.parent_id
668: AND sum.element_type_id IS NULL
669: AND sum.date_worked = FND_date.CANONICAL_TO_DATE(:date_worked)
670: AND det.element_type_id IN ELEMENT_LIST
671: AND FND_DATE.CANONICAL_TO_DATE(:session_date1) BETWEEN sum.effective_start_date
672: AND sum.effective_end_date
673: AND FND_DATE.CANONICAL_TO_DATE(:session_date2) BETWEEN det.effective_start_date
674: AND det.effective_end_date' ;
675:
669: AND sum.date_worked = FND_date.CANONICAL_TO_DATE(:date_worked)
670: AND det.element_type_id IN ELEMENT_LIST
671: AND FND_DATE.CANONICAL_TO_DATE(:session_date1) BETWEEN sum.effective_start_date
672: AND sum.effective_end_date
673: AND FND_DATE.CANONICAL_TO_DATE(:session_date2) BETWEEN det.effective_start_date
674: AND det.effective_end_date' ;
675:
676:
677:
898: hr_utility.trace('l_sql is '||l_sql);
899: END IF;
900:
901: OPEN l_refcursor FOR l_sql USING g_hol_tim_id,
902: FND_DATE.DATE_TO_CANONICAL(g_hol_date_worked),
903: FND_DATE.DATE_TO_CANONICAL(g_sum_session_date),
904: FND_DATE.DATE_TO_CANONICAL(g_sum_session_date);
905:
906: FETCH l_refcursor INTO l_paid_hours;
899: END IF;
900:
901: OPEN l_refcursor FOR l_sql USING g_hol_tim_id,
902: FND_DATE.DATE_TO_CANONICAL(g_hol_date_worked),
903: FND_DATE.DATE_TO_CANONICAL(g_sum_session_date),
904: FND_DATE.DATE_TO_CANONICAL(g_sum_session_date);
905:
906: FETCH l_refcursor INTO l_paid_hours;
907:
900:
901: OPEN l_refcursor FOR l_sql USING g_hol_tim_id,
902: FND_DATE.DATE_TO_CANONICAL(g_hol_date_worked),
903: FND_DATE.DATE_TO_CANONICAL(g_sum_session_date),
904: FND_DATE.DATE_TO_CANONICAL(g_sum_session_date);
905:
906: FETCH l_refcursor INTO l_paid_hours;
907:
908: CLOSE l_refcursor;