DBA Data[Home] [Help]

APPS.POS_SUPP_APPR dependencies on PER_JOBS

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

1498: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
1499: end if;
1500:
1501: if l_job_or_position is null and l_job_id is not null then
1502: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
1503: end if;
1504:
1505: if g_fnd_debug = 'Y' then
1506: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN