APPS.GHR_WGI_PKG dependencies on GHR_POIS

Line 273: l_grp_box_id ghr_pois.groupbox_id%type;

269: l_remark2_info3 ghr_pa_remarks.remark_code_information3%TYPE
270: := NULL;
271: l_commit NUMBER;
272: ------------ Bug 3680601
273: l_grp_box_id ghr_pois.groupbox_id%type;
274: l_no_groupbox_exception EXCEPTION;
275: l_from_asg_exception EXCEPTION;
276: l_retained_grade_exception EXCEPTION;
277: l_max_step_exception EXCEPTION;

Line 279: CURSOR c_check_group_box(c_po_id ghr_pois.personnel_office_id%type) IS

275: l_from_asg_exception EXCEPTION;
276: l_retained_grade_exception EXCEPTION;
277: l_max_step_exception EXCEPTION;
278:
279: CURSOR c_check_group_box(c_po_id ghr_pois.personnel_office_id%type) IS
280: SELECT groupbox_id
281: FROM ghr_pois
282: WHERE personnel_office_id = c_po_id;
283: --

Line 281: FROM ghr_pois

277: l_max_step_exception EXCEPTION;
278:
279: CURSOR c_check_group_box(c_po_id ghr_pois.personnel_office_id%type) IS
280: SELECT groupbox_id
281: FROM ghr_pois
282: WHERE personnel_office_id = c_po_id;
283: --
284: -- Bug#5482191 Added effective date condition.
285: CURSOR get_sal_chg_fam