APPS.POR_AME_APPROVAL_LIST dependencies on PER_JOBS

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

2260: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
2261: end if;
2262:
2263: if l_job_or_position is null and l_job_id is not null then
2264: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
2265: end if;
2266:
2267: if g_fnd_debug = 'Y' then
2268: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

2638: SELECT name INTO x_title FROM per_all_positions WHERE position_id = l_position_id;
2639: end if;
2640:
2641: if x_title is null and l_job_id is not null then
2642: SELECT name INTO x_title FROM per_jobs WHERE job_id = l_job_id;
2643: end if;
2644:
2645: if g_fnd_debug = 'Y' then
2646: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN

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

3106: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
3107: end if;
3108:
3109: if l_job_or_position is null and l_job_id is not null then
3110: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
3111: end if;
3112:
3113: if g_fnd_debug = 'Y' then
3114: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN