DBA Data[Home] [Help]

APPS.HXT_TIME_DETAIL dependencies on PER_ASSIGNMENTS_F

Line 742: per_assignments_f asm,

738: FROM hxt_pay_element_types_f_ddf_v eltv,
739: pay_element_types_f elt,
740: hxt_earning_policies egp,
741: hxt_per_aei_ddf_v asmv,
742: per_assignments_f asm,
743: hxt_det_hours_worked hrw,
744: hxt_timecards tim
745: WHERE hrw.parent_id > 0
746: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 811: per_assignments_f asm,

807: pay_element_types_f elt,
808: hxt_earn_groups erg,
809: hxt_earning_policies egp,
810: hxt_per_aei_ddf_v asmv,
811: per_assignments_f asm,
812: hxt_det_hours_worked hrw,
813: hxt_timecards tim
814: WHERE hrw.parent_id > 0
815: AND hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,

Line 864: per_assignments_f asm,

860: FROM hxt_pay_element_types_f_ddf_v eltv,
861: pay_element_types_f elt,
862: hxt_earning_policies egp,
863: hxt_per_aei_ddf_v asmv,
864: per_assignments_f asm,
865: hxt_det_hours_worked hrw,
866: hxt_timecards tim
867: WHERE hrw.parent_id > 0
868: AND hrw.date_worked = g_date_worked

Line 1093: per_assignments_f asm,

1089: FROM hxt_pay_element_types_f_ddf_v eltv,
1090: pay_element_types_f elt,
1091: hxt_earning_policies egp,
1092: hxt_per_aei_ddf_v asmv,
1093: per_assignments_f asm,
1094: hxt_det_hours_worked hrw,
1095: hxt_timecards tim
1096: WHERE hrw.date_worked BETWEEN NEXT_DAY (g_date_worked - 7,
1097: start_day_of_week