DBA Data[Home] [Help]

APPS.GHR_SF52_API dependencies on PER_GRADES

Line 5031: ,per_grades grd

5027: CURSOR cur_det_grd(l_grade_id NUMBER) IS
5028: SELECT gdf.segment1 pay_plan
5029: ,gdf.segment2 grade_or_level
5030: FROM per_grade_definitions gdf
5031: ,per_grades grd
5032: WHERE grd.grade_id = l_grade_id
5033: AND grd.grade_definition_id = gdf.grade_definition_id
5034: AND grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
5035:

Line 5057: l_detail_grade PER_GRADES.name%type;

5053: l_detail_location_id ghr_pa_request_extra_info.rei_information12%TYPE;
5054: l_detail_org ghr_pa_request_extra_info.rei_information13%TYPE;
5055:
5056: l_detail_position_name hr_all_positions_f.name%type;
5057: l_detail_grade PER_GRADES.name%type;
5058: l_detail_job HR_LOOKUPS.MEANING%type;
5059: l_detail_pay_plan ghr_pa_requests.from_pay_plan%type;
5060: l_detail_location varchar2(200);
5061: l_record_found BOOLEAN default FALSE;