APPS.PQH_WKS_ERROR_CHK dependencies on PER_JOBS

Line 48: cursor c3 is select business_group_id from per_jobs

44: from pqh_worksheet_details
45: where worksheet_detail_id = p_worksheet_detail_id;
46: cursor c2 is select business_group_id from hr_positions
47: where position_id = l_position_id;
48: cursor c3 is select business_group_id from per_jobs
49: where job_id = l_job_id;
50: cursor c4 is select business_group_id from per_grades
51: where grade_id = l_grade_id;
52: cursor c5 is select business_group_id from pqh_position_transactions

Line 2123: l_job_name per_jobs.name%TYPE;

2119:
2120: l_proc varchar2(72) := g_package||'set_wks_log_context';
2121: l_worksheet_details_rec pqh_worksheet_details%ROWTYPE;
2122: l_position_name hr_positions.name%TYPE;
2123: l_job_name per_jobs.name%TYPE;
2124: l_organization_name hr_organization_units.name%TYPE;
2125: l_grade_name per_grades.name%TYPE;
2126:
2127: CURSOR csr_wks_detail_rec IS