APPS.HR_UTIL_MISC_SS dependencies on PER_ALL_PEOPLE_F

Line 630: FROM per_all_people_f per

626:
627: -- Local Cursors
628: CURSOR csr_per_npw_flag IS
629: SELECT nvl(current_npw_flag,'N')
630: FROM per_all_people_f per
631: WHERE per.person_id = p_person_id
632: AND p_eff_date BETWEEN per.effective_start_date AND per.effective_end_date;
633:
634: CURSOR csr_fnd_func_details (p_func_name VARCHAR2)IS

Line 1377: return per_all_people_f.business_group_id%Type

1373: p_function_id IN number,
1374: p_bg_id IN number,
1375: p_person_id IN number
1376: )
1377: return per_all_people_f.business_group_id%Type
1378: IS
1379: --local variable
1380: l_proc constant varchar2(100) := g_package || ' getBusinessGroup';
1381: l_func_name varchar2(100) default null;

Line 2283: select BUSINESS_GROUP_ID into l_business_grp_id from per_all_people_f where

2279: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,5);
2280:
2281: else
2282:
2283: select BUSINESS_GROUP_ID into l_business_grp_id from per_all_people_f where
2284: person_id = l_person_id and trunc(sysdate) between effective_start_date and effective_end_date;
2285:
2286: hr_utility.set_location('l_business_grp_Id: ' || l_business_grp_Id,6);
2287: end if;

Line 2337: select BUSINESS_GROUP_ID into l_business_group_id from per_all_people_f where

2333: hr_utility.set_location('Entering: '|| l_proc,5);
2334:
2335:
2336:
2337: select BUSINESS_GROUP_ID into l_business_group_id from per_all_people_f where
2338: person_id = p_person_id and trunc(sysdate) between effective_start_date and effective_end_date;
2339:
2340: hr_utility.set_location('l_business_group_id: ' || l_business_group_id,6);
2341:

Line 2600: select distinct global_name,local_name into l_manager_global_name,l_manager_local_name from per_all_people_f where person_id = l_manager_id

2596:
2597:
2598:
2599: if ( l_manager_id is not null) then
2600: select distinct global_name,local_name into l_manager_global_name,l_manager_local_name from per_all_people_f where person_id = l_manager_id
2601: and trunc(sysdate) between effective_start_date and effective_end_date;
2602: else
2603: return null;
2604: end if;