[Home] [Help]
289: select asg.assignment_id
290: ,asg.object_version_number
291: ,asg.vacancy_id
292: from per_all_assignments_f asg
293: ,per_assignment_status_types ast
294: where asg.assignment_status_type_id = ast.assignment_status_type_id
295: and asg.person_id = c_person_id
296: and asg.business_group_id = c_business_group_id
297: and (c_assignment_id is null or
311: select asg.assignment_id
312: ,asg.object_version_number
313: ,asg.vacancy_id
314: from per_all_assignments_f asg
315: ,per_assignment_status_types ast
316: where asg.assignment_status_type_id = ast.assignment_status_type_id
317: and asg.person_id = c_person_id
318: and asg.business_group_id = c_business_group_id
319: and (c_assignment_id is null or
330: ) is
331: select assignment_status_type_id
332: ,active_flag
333: ,per_system_status
334: from per_assignment_status_types
335: where per_system_status = 'ACCEPTED'
336: and (business_group_id = c_business_group_id
337: or legislation_code = c_leg_code
338: or (legislation_code is null
2490: -- added by psengupt
2491: -- first we need to change the assignment status using hr_assignment_internal package
2492: --then change the other assignment details
2493: Select PER_SYSTEM_STATUS into l_expected_system_status
2494: from per_assignment_status_types
2495: where assignment_status_type_id = l_asg_rec.assignment_status_type_id;
2496:
2497: hr_assignment_swi.update_apl_asg
2498: (p_effective_date => p_effective_date