DBA Data[Home] [Help]

APPS.POS_SUPP_APPR dependencies on PER_JOBS

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

1527: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
1528: end if;
1529:
1530: if l_job_or_position is null and l_job_id is not null then
1531: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;
1532: end if;
1533:
1534: if g_fnd_debug = 'Y' then
1535: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) THEN