APPS.HR_PROCESS_PERSON_SS dependencies on PER_PERSON_TYPES

Line 26: FROM per_person_types ppt

22:
23: --global cursor for getting system_person_type
24: CURSOR gc_get_sys_person_type (p_person_type_id in number) IS
25: SELECT ppt.system_person_type
26: FROM per_person_types ppt
27: WHERE ppt.person_type_id = p_person_type_id;
28:
29:
30: -- Global cursor

Line 195: per_person_types ppt

191: IS
192:
193: SELECT ptu.person_type_id
194: FROM per_person_type_usages_f ptu,
195: per_person_types ppt
196: WHERE ptu.person_id = p_person_id
197: AND p_effective_date between ptu.effective_start_date
198: and ptu.effective_end_date
199: AND ptu.person_type_id = ppt.person_type_id

Line 5611: l_sys_person_type per_person_types.system_person_type%type;

5607: l_current_npw_flag per_all_people_f.current_npw_flag%type;
5608: l_effective_date date;
5609: l_appl_assignment_id number;
5610: l_person_type_id per_all_people_f.person_type_id%type;
5611: l_sys_person_type per_person_types.system_person_type%type;
5612: l_proc varchar2(72) := g_package||'process_api';
5613: l_business_grp_Id number;
5614: login_person_id number;
5615:

Line 7826: l_sys_person_type per_person_types.system_person_type%type;

7822: l_vendor_id number default null;
7823: l_benefit_group_id number default null;
7824: l_fte_capacity number default null;
7825: l_person_type_id number default null;
7826: l_sys_person_type per_person_types.system_person_type%type;
7827: -- start cobra codes
7828: l_assignment_extra_info_id number;
7829: l_aei_object_version_number number;
7830: prflvalue varchar2(2000) default null;