2: /* $Header: hrhdutilss.pkh 120.2.12010000.5 2008/12/12 13:38:42 tkghosh ship $ */
3: --
4: --
5: FUNCTION get_person_id
6: ( emp_id IN per_all_people_f.employee_number%type,
7: bg_id IN per_all_people_f.business_group_id%type,
8: cwk_id IN per_all_people_f.npw_number%type)
9: RETURN varchar2;
10:
3: --
4: --
5: FUNCTION get_person_id
6: ( emp_id IN per_all_people_f.employee_number%type,
7: bg_id IN per_all_people_f.business_group_id%type,
8: cwk_id IN per_all_people_f.npw_number%type)
9: RETURN varchar2;
10:
11: FUNCTION get_assgn_id
4: --
5: FUNCTION get_person_id
6: ( emp_id IN per_all_people_f.employee_number%type,
7: bg_id IN per_all_people_f.business_group_id%type,
8: cwk_id IN per_all_people_f.npw_number%type)
9: RETURN varchar2;
10:
11: FUNCTION get_assgn_id
12: ( pers_id IN per_all_people_f.person_id%type)
8: cwk_id IN per_all_people_f.npw_number%type)
9: RETURN varchar2;
10:
11: FUNCTION get_assgn_id
12: ( pers_id IN per_all_people_f.person_id%type)
13: RETURN varchar2;
14:
15: FUNCTION get_person_status
16: ( person_id IN per_all_people_f.person_id%type)
12: ( pers_id IN per_all_people_f.person_id%type)
13: RETURN varchar2;
14:
15: FUNCTION get_person_status
16: ( person_id IN per_all_people_f.person_id%type)
17: RETURN varchar2;
18:
19: FUNCTION get_assign_status
20: ( assig_id IN per_all_assignments_f.assignment_id%type)