APPS.PQH_WKS_ERROR_CHK dependencies on PER_GRADES

Line 50: cursor c4 is select business_group_id from per_grades

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
53: where position_transaction_id = l_position_transaction_id;
54: begin

Line 2125: l_grade_name per_grades.name%TYPE;

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
2128: SELECT *
2129: FROM pqh_worksheet_details