APPS.HXT_TIME_GEN dependencies on PER_ASSIGNMENTS_F

Line 85: per_assignments_f asm

81: per_people_f ppl,
82: hxt_earning_policies egp,
83: hxt_per_aei_ddf_v aeiv,
84: per_assignment_status_types ast,
85: per_assignments_f asm
86: WHERE ptp.payroll_id = asm.payroll_id
87: AND ast.assignment_status_type_id = asm.assignment_status_type_id
88: AND ast.pay_system_status = 'P' -- Check payroll status
89: AND ast.per_system_status = 'ACTIVE_ASSIGN'

Line 1249: per_assignments_f asm

1245: AND NOT EXISTS (
1246: SELECT 'x'
1247: FROM per_time_periods ptp,
1248: hxt_per_aei_ddf_v aeiv,
1249: per_assignments_f asm
1250: WHERE asm.person_id = tim.for_person_id
1251: AND ptp.start_date
1252: BETWEEN asm.effective_start_date
1253: AND asm.effective_end_date

Line 1342: per_assignments_f asm

1338: -- to no-autogen mid-period. We will need to look at this later.
1339: AND EXISTS ( SELECT 'x'
1340: FROM per_time_periods ptp,
1341: hxt_per_aei_ddf_v asmv,
1342: per_assignments_f asm
1343: WHERE asm.person_id = tim.for_person_id
1344: -- next 2 lines copied from g_cur_asm
1345: AND asm.effective_start_date <= ptp.end_date
1346: AND asm.effective_end_date >= ptp.start_date