[Home] [Help]
1449: and sra.resource_list_member_id=dra.resource_list_member_id
1450: and sra.task_id=dra.task_id
1451: and pbl.period_name not in (select s.period_name
1452: from gl_period_statuses s
1453: , pa_implementations_all i
1454: where s.application_id = pa_period_process_pkg.application_id
1455: and i.set_of_books_id = s.set_of_books_id
1456: and s.closing_status in ('C','P'));
1457: x_err_stage := 'About to delete unused resource assignments from dest';