APPS.HXT_TIME_DETAIL dependencies on HXT_TIMECARDS_F

Line 919: hxt_timecards_f tim

915: hxt_earning_policies egp,
916: hxt_per_aei_ddf_v asmv,
917: per_assignments_f asm,
918: hxt_det_hours_worked_f hrw,
919: hxt_timecards_f tim
920: WHERE hrw.parent_id > 0
921: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
922: start_day_of_week
923: )

Line 1040: hxt_timecards_f tim

1036: hxt_earning_policies egp,
1037: hxt_per_aei_ddf_v asmv,
1038: per_assignments_f asm,
1039: hxt_det_hours_worked_f hrw,
1040: hxt_timecards_f tim
1041: WHERE hrw.parent_id > 0
1042: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1043: start_day_of_week
1044: )

Line 1161: hxt_timecards_f tim

1157: hxt_earning_policies egp,
1158: hxt_per_aei_ddf_v asmv,
1159: per_assignments_f asm,
1160: hxt_det_hours_worked_f hrw,
1161: hxt_timecards_f tim
1162: WHERE hrw.parent_id > 0
1163: AND hrw.date_worked = g_date_worked
1164: AND asm.assignment_id = hrw.assignment_id
1165: AND hrw.date_worked BETWEEN asm.effective_start_date

Line 1310: hxt_timecards_f tim

1306: SELECT hrw.ROWID hrw_rowid, hrw.hours
1307: FROM hxt_pay_element_types_f_ddf_v eltv,
1308: pay_element_types_f elt,
1309: hxt_det_hours_worked_f hrw, --C421
1310: hxt_timecards_f tim
1311: WHERE hrw.date_worked = g_date_worked
1312: AND tim_id = g_tim_id
1313: AND tim.ID = hrw.tim_id
1314: AND session_date BETWEEN hrw.effective_start_date

Line 1528: hxt_timecards_f tim

1524: hxt_earning_policies egp,
1525: hxt_per_aei_ddf_v asmv,
1526: per_assignments_f asm,
1527: hxt_det_hours_worked_f hrw,
1528: hxt_timecards_f tim
1529: WHERE hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1530: start_day_of_week
1531: )
1532: AND g_date_worked

Line 4404: , hxt_timecards_f tim

4400: )
4401: IS
4402: SELECT sm.date_worked
4403: FROM hxt_sum_hours_worked_f sm
4404: , hxt_timecards_f tim
4405: WHERE tim.for_person_id = g_person_id
4406: AND sm.tim_id = tim.ID
4407: AND session_date BETWEEN sm.effective_start_date
4408: AND sm.effective_end_date

Line 4570: FROM hxt_sum_hours_worked_f sm, hxt_timecards_f tim

4566: a_date_worked DATE
4567: )
4568: IS
4569: SELECT sm.date_worked
4570: FROM hxt_sum_hours_worked_f sm, hxt_timecards_f tim
4571: WHERE tim.for_person_id = g_person_id
4572: AND sm.tim_id = tim.ID
4573: AND g_det_session_date BETWEEN sm.effective_start_date
4574: AND sm.effective_end_date

Line 4593: FROM hxt_det_hours_worked_f det, hxt_timecards_f tim

4589:
4590: CURSOR chk_det_for_wrkd_elements (a_date_start DATE)
4591: IS
4592: SELECT det.element_type_id
4593: FROM hxt_det_hours_worked_f det, hxt_timecards_f tim
4594: WHERE det.tim_id = tim.ID
4595: AND g_det_session_date BETWEEN det.effective_start_date
4596: AND det.effective_end_date
4597: AND g_det_session_date BETWEEN tim.effective_start_date

Line 5248: hxt_timecards_f tim

5244: INTO l_abs_count
5245: FROM hxt_pay_element_types_f_ddf_v eltv,
5246: pay_element_types_f elt,
5247: hxt_sum_hours_worked_f shr,
5248: hxt_timecards_f tim
5249: WHERE shr.date_worked BETWEEN NEXT_DAY (c_date_worked - 7,
5250: start_day_of_week
5251: )
5252: AND c_date_worked

Line 6667: hxt_timecards_f tim,

6663: CURSOR get_wkl_tot_incl_hrs_2day(effective_date DATE)
6664: IS
6665: SELECT NVL (SUM (hrw.hours), 0)
6666: FROM hxt_det_hours_worked_f hrw,
6667: hxt_timecards_f tim,
6668: hxt_earn_groups erg,
6669: hxt_earn_group_types egt,
6670: hxt_earning_policies erp,
6671: hxt_add_elem_info_f aei

Line 8063: hxt_timecards_f tim,

8059: SELECT NVL (SUM (hrw.hours), 0)
8060: FROM hxt_pay_element_types_f_ddf_v eltv,
8061: pay_element_types_f elt2,
8062: hxt_det_hours_worked_f hrw,
8063: hxt_timecards_f tim,
8064: hxt_earn_groups erg,
8065: hxt_earn_group_types egt,
8066: hxt_earning_policies erp
8067: WHERE tim.for_person_id = g_person_id