APPS.POS_SUPP_APPR dependencies on PER_ALL_POSITIONS

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

1523: AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
1524: and rownum = 1;
1525:
1526: if l_position_id is not null then
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;