APPS.HXT_TIME_GEN dependencies on PER_ASSIGNMENTS_F

Line 91: per_assignments_f asm

87: per_people_f ppl,
88: hxt_earning_policies egp,
89: hxt_per_aei_ddf_v aeiv,
90: per_assignment_status_types ast,
91: per_assignments_f asm
92: WHERE ptp.payroll_id = asm.payroll_id
93: AND ast.assignment_status_type_id = asm.assignment_status_type_id
94: AND ast.pay_system_status = 'P' -- Check payroll status
95: AND ast.per_system_status = 'ACTIVE_ASSIGN'

Line 180: per_assignments_f asm

176: per_people_f ppl,
177: hxt_earning_policies egp,
178: hxt_per_aei_ddf_v aeiv,
179: per_assignment_status_types ast,
180: per_assignments_f asm
181: WHERE ptp.payroll_id = asm.payroll_id
182: AND session_date BETWEEN tim.effective_start_date(+)
183: AND tim.effective_end_date(+)
184: AND ast.assignment_status_type_id = asm.assignment_status_type_id

Line 1382: per_assignments_f asm

1378: AND NOT EXISTS (
1379: SELECT 'x'
1380: FROM per_time_periods ptp,
1381: hxt_per_aei_ddf_v aeiv,
1382: per_assignments_f asm
1383: WHERE asm.person_id = tim.for_person_id
1384: AND ptp.start_date
1385: BETWEEN asm.effective_start_date
1386: AND asm.effective_end_date

Line 1475: per_assignments_f asm

1471: -- to no-autogen mid-period. We will need to look at this later.
1472: AND EXISTS ( SELECT 'x'
1473: FROM per_time_periods ptp,
1474: hxt_per_aei_ddf_v asmv,
1475: per_assignments_f asm
1476: WHERE asm.person_id = tim.for_person_id
1477: -- next 2 lines copied from g_cur_asm
1478: AND asm.effective_start_date <= ptp.end_date
1479: AND asm.effective_end_date >= ptp.start_date