1196: ,p_all_assignments
1197: in per_previous_jobs.all_assignments%type) is
1198: cursor csr_pjo_assignments is
1199: select previous_job_usage_id
1200: from per_previous_job_usages
1201: where previous_job_id = p_previous_job_id;
1202: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
1203: --
1204: l_proc varchar2(72) := g_package||'chk_all_assignments';
1198: cursor csr_pjo_assignments is
1199: select previous_job_usage_id
1200: from per_previous_job_usages
1201: where previous_job_id = p_previous_job_id;
1202: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
1203: --
1204: l_proc varchar2(72) := g_package||'chk_all_assignments';
1205: l_api_updating boolean;
1206: begin