APPS.HR_PERINFO_UTIL_WEB dependencies on PER_ALL_PEOPLE_F

Line 6: g_person_id per_all_people_f.person_id%TYPE;

2: /* $Header: hrpiutlw.pkb 120.3 2005/12/13 13:50:50 svittal noship $ */
3: c_prompts hr_util_misc_web.g_prompts%TYPE;
4: c_title hr_util_misc_web.g_title%TYPE;
5: g_package varchar2(31) := 'HR_PERINFO_UTIL_WEB';
6: g_person_id per_all_people_f.person_id%TYPE;
7: g_region_code constant varchar2(30) := 'HR_PERINFO_FRAMES';
8: g_application_id constant integer := 601;
9:
10:

Line 47: | MIN(EFFECTIVE_START_DATE) from per_all_people_f for a person.

43: | Purpose :
44: |
45: | This function will check if the passed in date is less than the date
46: | on which the person was created. The creation date of the person is
47: | MIN(EFFECTIVE_START_DATE) from per_all_people_f for a person.
48: |
49: | In Parameters :
50: |
51: | p_date : The date to be checked.

Line 68: FROM per_all_people_f pp

64: (p_date IN DATE,p_person_id IN NUMBER) RETURN BOOLEAN IS
65:
66: CURSOR csr_min_start_date IS
67: SELECT min(pp.effective_start_date)
68: FROM per_all_people_f pp
69: WHERE pp.person_id = p_person_id;
70:
71: l_start_date DATE;
72: BEGIN

Line 119: FROM per_all_people_f pp

115: ,p_ovn IN NUMBER) RETURN BOOLEAN IS
116:
117: CURSOR csr_chk_effective_date IS
118: SELECT 'Y'
119: FROM per_all_people_f pp
120: WHERE pp.person_id = p_person_id
121: AND pp.object_version_number = p_ovn
122: AND trunc(p_effective_date) < trunc(pp.effective_start_date);
123: