APPS.HXT_TIME_CLOCK dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 95: per_assignment_status_types ast,

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
99: AND ast.pay_system_status = 'P' -- Check payroll status

Line 1034: -- per_assignment_status_types ast,

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,
1038: -- hxt_work_shifts wsh,

Line 1072: per_assignment_status_types past,

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
1076: AND past.assignment_status_type_id = paf.assignment_status_type_id