DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on PER_ASSIGNMENTS_F

Line 65: per_assignments_f asm,

61: asmv.hxt_hour_deduction_policy, wsh.off_shift_prem_id,
62: wsh.shift_diff_ovrrd_id
63: FROM hxt_per_aei_ddf_v asmv,
64: per_assignment_status_types ast,
65: per_assignments_f asm,
66: hxt_shifts sht,
67: hxt_weekly_work_schedules wws,
68: hxt_work_shifts wsh,
69: hxt_rotation_schedules rts

Line 210: * assignment to be queried from the PER_ASSIGNMENTS_F table.

206: *

employee_number must identify a unique (considering date effectivity)
207: * person in the PER_PEOPLE_F table.
208: *

assignment_id is currently NOT USED. Value passed may be NULL.
209: * Assignment to be used for employee will be the first applicable
210: * assignment to be queried from the PER_ASSIGNMENTS_F table.
211: *

start_time will be used as the date worked for the block of time
212: * being logged. No consideration will be given to the possibility
213: * that a block of time worked may span into another day.
214: *

If adding time data to an already existing OTM Timecard, the