APPS.HR_HELPDESK_UTIL_SS dependencies on PER_ALL_PEOPLE_F

Line 8: ( emp_id IN per_all_people_f.employee_number%type,

4: -- Package variables
5: --
6:
7: FUNCTION get_person_id
8: ( emp_id IN per_all_people_f.employee_number%type,
9: bg_id IN per_all_people_f.business_group_id%type,
10: cwk_id IN per_all_people_f.npw_number%type)
11: RETURN varchar2
12: IS

Line 9: bg_id IN per_all_people_f.business_group_id%type,

5: --
6:
7: FUNCTION get_person_id
8: ( emp_id IN per_all_people_f.employee_number%type,
9: bg_id IN per_all_people_f.business_group_id%type,
10: cwk_id IN per_all_people_f.npw_number%type)
11: RETURN varchar2
12: IS
13: pers_id varchar2(10);

Line 10: cwk_id IN per_all_people_f.npw_number%type)

6:
7: FUNCTION get_person_id
8: ( emp_id IN per_all_people_f.employee_number%type,
9: bg_id IN per_all_people_f.business_group_id%type,
10: cwk_id IN per_all_people_f.npw_number%type)
11: RETURN varchar2
12: IS
13: pers_id varchar2(10);
14: begin

Line 19: from per_all_people_f

15:
16: if (trim(cwk_id) is not null or trim(cwk_id) <> 0) then
17:
18: select distinct person_id into pers_id
19: from per_all_people_f
20: where npw_number = cwk_id and
21: business_group_id = bg_id and
22: current_npw_flag='Y' and
23: sysdate between effective_start_date and

Line 29: from per_all_people_f

25:
26: else
27:
28: select distinct person_id into pers_id
29: from per_all_people_f
30: where employee_number = emp_id and
31: business_group_id = bg_id and
32: current_employee_flag='Y' and
33: sysdate between effective_start_date and

Line 47: (pers_id per_all_people_f.person_id%type )

43:
44: end get_person_id;
45:
46: FUNCTION get_assgn_id
47: (pers_id per_all_people_f.person_id%type )
48: RETURN varchar2 is
49: --pers_id varchar2(10);
50: ass_id varchar2(10);
51: begin

Line 72: ( person_id IN per_all_people_f.person_id%type)

68:
69: end get_assgn_id;
70:
71: FUNCTION get_person_status
72: ( person_id IN per_all_people_f.person_id%type)
73: RETURN varchar2 is
74: per_sts number;
75: begin
76: select count(*) into per_sts from per_people_f