DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on PER_PREVIOUS_JOB_USAGES

Line 1533: from per_previous_job_usages

1529: ,p_all_assignments
1530: in per_previous_employers.all_assignments%type) is
1531: cursor csr_pem_assignments is
1532: select previous_job_usage_id
1533: from per_previous_job_usages
1534: where previous_employer_id = p_previous_employer_id;
1535: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
1536: --
1537: l_proc varchar2(72) := g_package||'chk_all_assignments';

Line 1535: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;

1531: cursor csr_pem_assignments is
1532: select previous_job_usage_id
1533: from per_previous_job_usages
1534: where previous_employer_id = p_previous_employer_id;
1535: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
1536: --
1537: l_proc varchar2(72) := g_package||'chk_all_assignments';
1538: l_api_updating boolean;
1539: begin