DBA Data[Home] [Help]

APPS.HXT_TIME_CLOCK dependencies on HXT_PER_AEI_DDF_V

Line 94: hxt_per_aei_ddf_v aeiv,--ORACLE

90: aeiv.hxt_rotation_plan, --SIR344
91: egp.hcl_id
92: FROM hxt_earning_policies egp,
93: --ORACLE per_assignments_f_dfv asmv,
94: hxt_per_aei_ddf_v aeiv,--ORACLE
95: per_assignment_status_types ast,
96: per_assignments_f asm
97: WHERE c_person_id = asm.person_id
98: AND ast.assignment_status_type_id = asm.assignment_status_type_id

Line 1033: -- hxt_per_aei_ddf_v aeiv, --ORACLE

1029: -- wsh.off_shift_prem_id,
1030: -- wsh.shift_diff_ovrrd_id
1031: -- FROM hxt_earning_policies egp,
1032: ----ORACLE per_assignments_f_dfv asmv,
1033: -- hxt_per_aei_ddf_v aeiv, --ORACLE
1034: -- per_assignment_status_types ast,
1035: -- per_assignments_f asm,
1036: -- hxt_shifts sht,
1037: -- hxt_weekly_work_schedules wws,

Line 1071: hxt_per_aei_ddf_v aeiv,

1067: egp.egt_id,
1068: egp.pep_id,
1069: egp.pip_id
1070: FROM hxt_earning_policies egp,
1071: hxt_per_aei_ddf_v aeiv,
1072: per_assignment_status_types past,
1073: per_assignments_f paf
1074: WHERE c_assignment_id = paf.assignment_id
1075: AND c_date_worked BETWEEN paf.effective_start_date AND paf.effective_end_date