APPS.POS_SUPP_APPR dependencies on PER_ALL_POSITIONS

Line 1498: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;

1494: AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
1495: and rownum = 1;
1496:
1497: if l_position_id is not null then
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;