APPS.POR_AME_APPROVAL_LIST dependencies on PER_ALL_POSITIONS

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

2186: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2187: and rownum = 1;
2188:
2189: if l_position_id is not null then
2190: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
2191: end if;
2192:
2193: if l_job_or_position is null and l_job_id is not null then
2194: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;

Line 2568: SELECT name INTO x_title FROM per_all_positions WHERE position_id = l_position_id;

2564: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2565: and rownum = 1;
2566:
2567: if l_position_id is not null then
2568: SELECT name INTO x_title FROM per_all_positions WHERE position_id = l_position_id;
2569: end if;
2570:
2571: if x_title is null and l_job_id is not null then
2572: SELECT name INTO x_title FROM per_jobs WHERE job_id = l_job_id;

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

3026: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
3027: and rownum = 1;
3028:
3029: if l_position_id is not null then
3030: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
3031: end if;
3032:
3033: if l_job_or_position is null and l_job_id is not null then
3034: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;