eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.PER_ABS_BUS dependencies on FND_PROFILE

Line 409: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and

405: per_periods_of_service pos
406: where ppf.person_id = p_person_id
407: and ppf.person_id = pos.person_id
408: and ppf.current_employee_flag = 'Y'
409: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and
410: ppf.business_group_id = p_business_group_id)
411: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
412: and (p_date_projected_start is null or p_date_projected_start
413: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

Line 411: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')

407: and ppf.person_id = pos.person_id
408: and ppf.current_employee_flag = 'Y'
409: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and
410: ppf.business_group_id = p_business_group_id)
411: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
412: and (p_date_projected_start is null or p_date_projected_start
413: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))
414: and (p_date_projected_end is null or p_date_projected_end
415: between pos.date_start and nvl(pos.actual_termination_date,hr_api.g_eot))

Line 428: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and

424: where ppf.person_id = p_person_id
425: and ppf.person_id = pop.person_id
426: and ppf.person_id = pawv.person_id
427: and ppf.current_npw_flag = 'Y'
428: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and
429: ppf.business_group_id = p_business_group_id)
430: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
431: and (p_date_projected_start is null or p_date_projected_start
432: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))

Line 430: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')

426: and ppf.person_id = pawv.person_id
427: and ppf.current_npw_flag = 'Y'
428: and ((nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'N' and
429: ppf.business_group_id = p_business_group_id)
430: or nvl(fnd_profile.value('HR_CROSS_BUSINESS_GROUP'), 'N') = 'Y')
431: and (p_date_projected_start is null or p_date_projected_start
432: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))
433: and (p_date_projected_end is null or p_date_projected_end
434: between pop.date_start and nvl(pop.actual_termination_date,hr_api.g_eot))

Line 1203: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');

1199: fetch c_get_absence_info into l_hours_or_days,
1200: l_element_type_id;
1201: close c_get_absence_info;
1202:
1203: l_sch_based_dur := NVL(FND_PROFILE.Value('HR_SCH_BASED_ABS_CALC'),'N');
1204: l_sch_based_dur_found := FALSE;
1205: --
1206: IF l_sch_based_dur = 'Y' THEN
1207: --

Line 2574: nvl(fnd_profile.value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'X');

2570: -- auto-overwrite is set to Yes.
2571: --
2572: -- Bug 14659075
2573: l_auto_overwrite :=
2574: nvl(fnd_profile.value('PER_ABSENCE_DURATION_AUTO_OVERWRITE'),'X');
2575:
2576: hr_utility.set_location(l_proc, 30);
2577:
2578: If (l_use_formula)

Line 2876: if (nvl(fnd_profile.value('HR_ALLOW_NEG_ABS_BAL'),'Y') = 'N') then

2872: end;
2873:
2874: if (l_accrual_msg) then
2875: -- code change for 7688779 starts here
2876: if (nvl(fnd_profile.value('HR_ALLOW_NEG_ABS_BAL'),'Y') = 'N') then
2877:
2878: open csr_get_abs_type_name;
2879: fetch csr_get_abs_type_name into p_abs_type_name;
2880: close csr_get_abs_type_name;

Line 2922: if (nvl(fnd_profile.value('HR_ALLOW_NEG_ABS_BAL'),'Y') = 'N') then

2918: nvl(per_abs_shd.g_old_rec.absence_days, 0) - p_absence_days < 0)
2919: then
2920:
2921: -- code change for 7688779 starts here
2922: if (nvl(fnd_profile.value('HR_ALLOW_NEG_ABS_BAL'),'Y') = 'N') then
2923:
2924: open csr_get_abs_type_name;
2925: fetch csr_get_abs_type_name into p_abs_type_name;
2926: close csr_get_abs_type_name;