APPS.GHR_API dependencies on PER_PERSON_TYPES

Line 53: from per_all_people_f per,per_person_types ppt

49:
50: --
51: Cursor c_per_type(per_id number,eff_date date) is
52: Select ppt.system_person_type
53: from per_all_people_f per,per_person_types ppt
54: where per.person_id = per_id
55: and trunc(eff_date) between per.effective_start_date
56: and per.effective_end_date
57: and per.person_type_id = ppt.person_type_id;

Line 107: l_person_type per_person_types.system_person_type%type;

103: --
104: l_proc varchar2(72) := g_package||'retrieve_business_group_id';
105: l_person_found boolean := FALSE;
106: l_assignment_found boolean := FALSE;
107: l_person_type per_person_types.system_person_type%type;
108: --
109: cursor c_person (per_id number, eff_date date) is
110: select per.business_group_id
111: from per_all_people_f per

Line 2691: l_person_type per_person_types.system_person_type%type;

2687: --vsm
2688: l_business_group_id per_business_groups.business_group_id%type;
2689: l_result_code varchar2(30);
2690: l_assignment_data per_all_assignments_f%rowtype;
2691: l_person_type per_person_types.system_person_type%type;
2692: l_effective_date date;
2693: l_assignment_id per_assignments_f.assignment_id%type;
2694: v_assignment_id per_assignments_f.assignment_id%type;
2695: l_session ghr_history_api.g_session_var_type;

Line 2709: per_person_types ppt

2705: -- Cursor to get person type
2706: cursor c_person_type is
2707: select system_person_type
2708: from per_all_people_f ppf,
2709: per_person_types ppt
2710: where ppf.person_id = p_person_id
2711: and ppt.person_type_id = ppf.person_type_id;
2712: --
2713: cursor c_assignment_by_per_id (per_id number, eff_date date) is