APPS.HR_COMP_PROFILE_SS dependencies on PER_ALL_PEOPLE_F

Line 6: g_person_id per_all_people_f.person_id%type;

2: /* $Header: hrcprwrs.pkb 120.5.12020000.3 2012/07/05 17:55:34 amnaraya ship $ */
3: --
4: -- Private globals
5: g_package varchar2(30) := 'HR_COMP_PROFILE_SS';
6: g_person_id per_all_people_f.person_id%type;
7: g_business_group_id per_all_people_f.business_group_id%type;
8: g_language_code varchar2(5) default null;
9: g_invalid_entry exception;
10: g_invalid_competence exception;

Line 7: g_business_group_id per_all_people_f.business_group_id%type;

3: --
4: -- Private globals
5: g_package varchar2(30) := 'HR_COMP_PROFILE_SS';
6: g_person_id per_all_people_f.person_id%type;
7: g_business_group_id per_all_people_f.business_group_id%type;
8: g_language_code varchar2(5) default null;
9: g_invalid_entry exception;
10: g_invalid_competence exception;
11: --

Line 3859: from per_all_people_f

3855: --
3856:
3857: cursor csr_party_id is
3858: select party_id
3859: from per_all_people_f
3860: where person_id = p_person_id
3861: and business_group_id=p_business_group_id
3862: and sysdate between effective_start_date and effective_end_date;
3863: l_party_id per_all_people_f.party_id%type;

Line 3863: l_party_id per_all_people_f.party_id%type;

3859: from per_all_people_f
3860: where person_id = p_person_id
3861: and business_group_id=p_business_group_id
3862: and sysdate between effective_start_date and effective_end_date;
3863: l_party_id per_all_people_f.party_id%type;
3864: begin
3865: hr_utility.set_location('Entering: '|| l_proc,5);
3866: open csr_party_id;
3867: fetch csr_party_id into l_party_id;