APPS.GHR_CORR_CANC_SF52 dependencies on PER_GRADES

Line 3519: from per_grades grd,

3515:
3516: cursor c_grade_kff (grd_id number) is
3517: select gdf.segment1
3518: ,gdf.segment2
3519: from per_grades grd,
3520: per_grade_definitions gdf
3521: where grd.grade_id = grd_id
3522: and grd.grade_definition_id = gdf.grade_definition_id;
3523:

Line 5387: from per_grades grd,

5383:
5384: cursor c_grade_kff (grd_id number) is
5385: select gdf.segment1
5386: ,gdf.segment2
5387: from per_grades grd,
5388: per_grade_definitions gdf
5389: where grd.grade_id = grd_id
5390: and grd.grade_definition_id = gdf.grade_definition_id;
5391:

Line 6895: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,

6891: CURSOR c_from_data IS
6892: SELECT * FROM ghr_pa_requests
6893: WHERE pa_request_id = p_pa_request_id;
6894:
6895: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6896: c_pay_plan per_grades.name%type,
6897: c_grade per_grades.name%type,
6898: c_effective_date per_grades.date_from%type) IS
6899: SELECT grade_id

Line 6896: c_pay_plan per_grades.name%type,

6892: SELECT * FROM ghr_pa_requests
6893: WHERE pa_request_id = p_pa_request_id;
6894:
6895: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6896: c_pay_plan per_grades.name%type,
6897: c_grade per_grades.name%type,
6898: c_effective_date per_grades.date_from%type) IS
6899: SELECT grade_id
6900: FROM per_grades

Line 6897: c_grade per_grades.name%type,

6893: WHERE pa_request_id = p_pa_request_id;
6894:
6895: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6896: c_pay_plan per_grades.name%type,
6897: c_grade per_grades.name%type,
6898: c_effective_date per_grades.date_from%type) IS
6899: SELECT grade_id
6900: FROM per_grades
6901: WHERE business_group_id = c_business_group_id

Line 6898: c_effective_date per_grades.date_from%type) IS

6894:
6895: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6896: c_pay_plan per_grades.name%type,
6897: c_grade per_grades.name%type,
6898: c_effective_date per_grades.date_from%type) IS
6899: SELECT grade_id
6900: FROM per_grades
6901: WHERE business_group_id = c_business_group_id
6902: AND substr(name,1,2) = c_pay_plan

Line 6900: FROM per_grades

6896: c_pay_plan per_grades.name%type,
6897: c_grade per_grades.name%type,
6898: c_effective_date per_grades.date_from%type) IS
6899: SELECT grade_id
6900: FROM per_grades
6901: WHERE business_group_id = c_business_group_id
6902: AND substr(name,1,2) = c_pay_plan
6903: AND substr(name,length(name)-1) = c_grade
6904: AND c_effective_date BETWEEN NVL(date_from,to_date('01/01/1951','dd/mm/yyyy')) AND NVL(date_to,to_date('31/12/4712','dd/mm/yyyy'));

Line 6909: l_business_group_id per_grades.business_group_id%type;

6905:
6906: l_proc varchar2(30):='get_sf52_to_details_for_ia';
6907: l_dummy_varchar varchar2(30);
6908: l_sf52_ia_rec ghr_pa_requests%rowtype;
6909: l_business_group_id per_grades.business_group_id%type;
6910:
6911: BEGIN
6912: -- First assign the current From pos items to To pos items
6913: hr_utility.set_location( 'Entering ' || l_proc, 5);

Line 7290: from per_grades grd,

7286: cursor c_grade_kff (grd_id number)
7287: is
7288: select gdf.segment1
7289: ,gdf.segment2
7290: from per_grades grd,
7291: per_grade_definitions gdf
7292: where grd.grade_id = grd_id
7293: and grd.grade_definition_id = gdf.grade_definition_id;
7294: