APPS.PQH_WKS_ERROR_CHK dependencies on HR_POSITIONS

Line 46: cursor c2 is select business_group_id from hr_positions

42: l_res_organization_id number;
43: cursor c1 is select position_id,organization_id,job_id,grade_id,position_transaction_id
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

Line 882: l_availability_status_id hr_positions.availability_status_id%type;

878: l_message_text_out fnd_new_messages.message_text%TYPE;
879: l_count number;
880: l_error_flag varchar2(10) := 'N';
881: l_pc_posn_status varchar2(30);
882: l_availability_status_id hr_positions.availability_status_id%type;
883:
884:
885: CURSOR csr_wks_details IS
886: SELECT *

Line 2122: l_position_name hr_positions.name%TYPE;

2118: */
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: