APPS.IRC_UTILITIES_PKG dependencies on PER_JOBS

Line 2092: FROM per_jobs

2088: END IF;
2089: IF(p_job_id IS NOT NULL) THEN
2090: SELECT name
2091: INTO l_job_name
2092: FROM per_jobs
2093: WHERE job_id = p_job_id;
2094:
2095: OPEN csr_select_column_names('PER_JOBS');
2096: FETCH csr_select_column_names

Line 2095: OPEN csr_select_column_names('PER_JOBS');

2091: INTO l_job_name
2092: FROM per_jobs
2093: WHERE job_id = p_job_id;
2094:
2095: OPEN csr_select_column_names('PER_JOBS');
2096: FETCH csr_select_column_names
2097: INTO l_column_name;
2098:
2099: IF csr_select_column_names%found THEN

Line 2102: || ' from per_jobs where job_id = :job_id';

2098:
2099: IF csr_select_column_names%found THEN
2100: query_stmt := 'select '
2101: || l_column_name
2102: || ' from per_jobs where job_id = :job_id';
2103: EXECUTE immediate query_stmt INTO return_val USING p_job_id;
2104: END IF;
2105: CLOSE csr_select_column_names;
2106: IF (return_val IS NOT NULL) THEN