DBA Data[Home] [Help]

APPS.PER_PEM_BUS dependencies on PER_PREVIOUS_JOB_USAGES

Line 1509: from per_previous_job_usages

1505: ,p_all_assignments
1506: in per_previous_employers.all_assignments%type) is
1507: cursor csr_pem_assignments is
1508: select previous_job_usage_id
1509: from per_previous_job_usages
1510: where previous_employer_id = p_previous_employer_id;
1511: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
1512: --
1513: l_proc varchar2(72) := g_package||'chk_all_assignments';

Line 1511: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;

1507: cursor csr_pem_assignments is
1508: select previous_job_usage_id
1509: from per_previous_job_usages
1510: where previous_employer_id = p_previous_employer_id;
1511: l_previous_job_usage_id per_previous_job_usages.previous_job_usage_id%type;
1512: --
1513: l_proc varchar2(72) := g_package||'chk_all_assignments';
1514: l_api_updating boolean;
1515: begin