DBA Data[Home] [Help]

APPS.HXT_TIME_COLLECTION dependencies on HXT_PER_AEI_DDF_V

Line 41: hxt_per_aei_ddf_v asmv,

37: IS
38: SELECT asm.payroll_id, asm.assignment_id, asm.effective_start_date,
39: asm.effective_end_date, asmv.hxt_rotation_plan, egp.hcl_id
40: FROM hxt_earning_policies egp,
41: hxt_per_aei_ddf_v asmv,
42: per_assignment_status_types ast,
43: per_all_assignments_f asm
44: WHERE c_person_id = asm.person_id
45: AND asm.primary_flag = 'Y'

Line 63: FROM hxt_per_aei_ddf_v asmv,

59: IS
60: SELECT asmv.hxt_earning_policy, asmv.hxt_shift_differential_policy,
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,