[Home] [Help]
1434: FROM per_grade_definitions gdf,
1435: per_grades grd
1436: WHERE grd.grade_id = p_pos_valid_grade.target_grade
1437: AND grd.grade_definition_id = gdf.grade_definition_id
1438: AND grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1439:
1440: CURSOR cur_grd2 IS
1441: SELECT grd.grade_id
1442: FROM per_grade_definitions gdf,
1443: per_grades grd
1444: WHERE grd.grade_definition_id = gdf.grade_definition_id
1445: and gdf.segment1 = l_pay_plan
1446: and gdf.segment2 = l_grade_or_level
1447: and grd.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID');
1448: --End Bug 5919705
1449: l_first_noa_code ghr_pa_requests.first_noa_code%type;
1450: l_second_noa_code ghr_pa_requests.second_noa_code%type;
1451: l_fam_code ghr_pa_requests.noa_family_code%type;
4364: -- Checking whether Payroll installed or not. Skipping Final Process if the the Payrol
4365: -- Installed. If there is no payroll installed then doing Finall process.
4366: -- Assuming HR_USER_TYPE will be 'PER' if the payroll is not installed, so doing Final
4367: -- Process for HR user
4368: l_hr_user_type := fnd_profile.value('HR_USER_TYPE');
4369: IF l_hr_user_type = 'PER' THEN
4370: begin
4371:
4372: savepoint final_process;
4438: End if;
4439: --
4440:
4441: -- Address creation
4442: l_hr_user_type := fnd_profile.value('HR_USER_TYPE');
4443: hr_utility.set_location('in address'||l_hr_user_type,1000);
4444: IF l_hr_user_type = 'INT' THEN
4445: hr_utility.set_location('in per addresses',1000);
4446: If l_create_address = 'Y' or l_update_address = 'Y' then
5050: -- CHECK # :- Existence of PAYROLL Product
5051: ----**********************************************************************
5052: IF (hr_utility.chk_product_install('GHR','US') = TRUE
5053: and hr_utility.chk_product_install('PAY', 'US') = TRUE
5054: and fnd_profile.value('HR_USER_TYPE')='INT')
5055: THEN
5056: l_pay_intg:=TRUE;
5057: ELSE
5058: l_pay_intg:=FALSE;