APPS.POR_AME_APPROVAL_LIST dependencies on PER_JOBS

Line 2194: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;

2190: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
2191: end if;
2192:
2193: if l_job_or_position is null and l_job_id is not null then
2194: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
2195: end if;
2196:
2197: if g_fnd_debug = 'Y' then
2198: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 2572: SELECT name INTO x_title FROM per_jobs WHERE job_id = l_job_id;

2568: SELECT name INTO x_title FROM per_all_positions WHERE position_id = l_position_id;
2569: end if;
2570:
2571: if x_title is null and l_job_id is not null then
2572: SELECT name INTO x_title FROM per_jobs WHERE job_id = l_job_id;
2573: end if;
2574:
2575: if g_fnd_debug = 'Y' then
2576: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

Line 3034: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;

3030: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
3031: end if;
3032:
3033: if l_job_or_position is null and l_job_id is not null then
3034: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
3035: end if;
3036:
3037: if g_fnd_debug = 'Y' then
3038: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN