APPS.GHR_CORR_CANC_SF52 dependencies on PER_GRADES

Line 3213: from per_grades grd,

3209:
3210: cursor c_grade_kff (grd_id number) is
3211: select gdf.segment1
3212: ,gdf.segment2
3213: from per_grades grd,
3214: per_grade_definitions gdf
3215: where grd.grade_id = grd_id
3216: and grd.grade_definition_id = gdf.grade_definition_id;
3217:

Line 5045: from per_grades grd,

5041:
5042: cursor c_grade_kff (grd_id number) is
5043: select gdf.segment1
5044: ,gdf.segment2
5045: from per_grades grd,
5046: per_grade_definitions gdf
5047: where grd.grade_id = grd_id
5048: and grd.grade_definition_id = gdf.grade_definition_id;
5049:

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

6536: CURSOR c_from_data IS
6537: SELECT * FROM ghr_pa_requests
6538: WHERE pa_request_id = p_pa_request_id;
6539:
6540: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6541: c_pay_plan per_grades.name%type,
6542: c_grade per_grades.name%type,
6543: c_effective_date per_grades.date_from%type) IS
6544: SELECT grade_id

Line 6541: c_pay_plan per_grades.name%type,

6537: SELECT * FROM ghr_pa_requests
6538: WHERE pa_request_id = p_pa_request_id;
6539:
6540: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6541: c_pay_plan per_grades.name%type,
6542: c_grade per_grades.name%type,
6543: c_effective_date per_grades.date_from%type) IS
6544: SELECT grade_id
6545: FROM per_grades

Line 6542: c_grade per_grades.name%type,

6538: WHERE pa_request_id = p_pa_request_id;
6539:
6540: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6541: c_pay_plan per_grades.name%type,
6542: c_grade per_grades.name%type,
6543: c_effective_date per_grades.date_from%type) IS
6544: SELECT grade_id
6545: FROM per_grades
6546: WHERE business_group_id = c_business_group_id

Line 6543: c_effective_date per_grades.date_from%type) IS

6539:
6540: CURSOR c_grade_id(c_business_group_id per_grades.business_group_id%type,
6541: c_pay_plan per_grades.name%type,
6542: c_grade per_grades.name%type,
6543: c_effective_date per_grades.date_from%type) IS
6544: SELECT grade_id
6545: FROM per_grades
6546: WHERE business_group_id = c_business_group_id
6547: AND substr(name,1,2) = c_pay_plan

Line 6545: FROM per_grades

6541: c_pay_plan per_grades.name%type,
6542: c_grade per_grades.name%type,
6543: c_effective_date per_grades.date_from%type) IS
6544: SELECT grade_id
6545: FROM per_grades
6546: WHERE business_group_id = c_business_group_id
6547: AND substr(name,1,2) = c_pay_plan
6548: AND substr(name,length(name)-1) = c_grade
6549: 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 6554: l_business_group_id per_grades.business_group_id%type;

6550:
6551: l_proc varchar2(30):='get_sf52_to_details_for_ia';
6552: l_dummy_varchar varchar2(30);
6553: l_sf52_ia_rec ghr_pa_requests%rowtype;
6554: l_business_group_id per_grades.business_group_id%type;
6555:
6556: BEGIN
6557: -- First assign the current From pos items to To pos items
6558: hr_utility.set_location( 'Entering ' || l_proc, 5);