135: ,asg.business_group_id
136: FROM
137: hri_eq_sprvsr_hrchy_chgs eq
138: ,per_all_assignments_f asg
139: ,per_assignment_status_types ast
140: WHERE asg.assignment_type IN ('E', 'C')
141: AND asg.primary_flag = 'Y'
142: AND eq.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id
143: AND asg.effective_end_date >= eq.erlst_evnt_effective_date
234: ,asg.assignment_type
235: ,asg.business_group_id
236: FROM
237: per_all_assignments_f asg
238: ,per_assignment_status_types ast
239: WHERE asg.assignment_type IN ('E', 'C')
240: AND asg.primary_flag = 'Y'
241: AND asg.assignment_id BETWEEN p_start_asg_id AND p_end_asg_id
242: AND asg.effective_end_date >= g_refresh_start_date
329: ,g_user
330: ,g_sysdate
331: FROM
332: per_all_assignments_f asg
333: ,per_assignment_status_types ast
334: ,per_periods_of_service pos
335: ,per_periods_of_placement ppp
336: WHERE asg.assignment_type IN ('E', 'C')
337: AND asg.primary_flag = 'Y'