APPS.POR_AME_APPROVAL_LIST dependencies on PER_ALL_POSITIONS

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

2256: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2257: and rownum = 1;
2258:
2259: if l_position_id is not null then
2260: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
2261: end if;
2262:
2263: if l_job_or_position is null and l_job_id is not null then
2264: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;

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

2634: and TRUNC ( effective_start_date ) <= TRUNC(SYSDATE) AND NVL(effective_end_date, TRUNC( SYSDATE)) >= TRUNC(SYSDATE)
2635: and rownum = 1;
2636:
2637: if l_position_id is not null then
2638: SELECT name INTO x_title FROM per_all_positions WHERE position_id = l_position_id;
2639: end if;
2640:
2641: if x_title is null and l_job_id is not null then
2642: SELECT name INTO x_title FROM per_jobs WHERE job_id = l_job_id;

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

3102: )
3103: and rownum = 1;
3104:
3105: if l_position_id is not null then
3106: SELECT name INTO l_job_or_position FROM per_all_positions WHERE position_id = l_position_id;
3107: end if;
3108:
3109: if l_job_or_position is null and l_job_id is not null then
3110: SELECT name INTO l_job_or_position FROM per_jobs WHERE job_id = l_job_id;