[Home] [Help]
226: ,ppf.employee_number
227: ,ppt.person_type_id
228: ,ppf.person_id
229: from per_all_people_f ppf
230: ,per_person_types ppt
231: where ppt.person_type_id = ppf.person_type_id
232: and ppf.business_group_id = c_bg_grp_id
233: and ppt.business_group_id = ppf.business_group_id
234: and ppt.active_flag = 'Y'
246: ,ppt.active_flag
247: ,ppt.system_person_type
248: ,ppt.user_person_type
249: from per_person_type_usages_f ptu
250: ,per_person_types ppt
251: where ptu.person_id = c_person_id
252: and ppt.business_group_id = c_business_group_id
253: and ppt.person_type_id = ptu.person_type_id
254: and c_effective_date between ptu.effective_start_date
267: select ptu.person_type_id
268: ,ppt.system_person_type
269: ,ppt.user_person_type
270: from per_person_type_usages_f ptu
271: ,per_person_types ppt
272: where ptu.person_id = c_person_id
273: and ppt.person_type_id = ptu.person_type_id
274: and ppt.business_group_id = c_business_group_id
275: and ptu.effective_start_date > c_effective_date
345: --
346: cursor csr_per_type(c_person_type_id number
347: ,c_business_group_id in number) is
348: select ppt.user_person_type
349: from per_person_types ppt
350: where ppt.person_type_id = c_person_type_id
351: and ppt.business_group_id = c_business_group_id;
352: --
353: -- Cursor to get the Grade Name
2146: ) is
2147:
2148: cursor csr_type (c_person_type_id in number) is
2149: select *
2150: from per_person_types
2151: where person_type_id = c_person_type_id
2152: and business_group_id = p_business_group_id;
2153:
2154: l_pty_rec csr_type%rowtype;
2168: ,ppf.person_id
2169: ,ppf.object_version_number
2170: from per_all_people_f ppf
2171: ,per_person_type_usages_f ptu
2172: ,per_person_types ppt
2173: where ptu.person_type_id = ppf.person_type_id
2174: and ppt.person_type_id = ptu.person_type_id
2175: and ppt.business_group_id = ppf.business_group_id
2176: and ppf.business_group_id = c_bg_grp_id
2190: e_active_empcwk exception;
2191: e_active_apl exception;
2192: l_person_id per_all_people_f.person_id%type;
2193: l_party_id per_all_people_f.person_id%type;
2194: l_user_person_type per_person_types.user_person_type%TYPE;
2195: l_effective_date date;
2196: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';
2197: begin
2198: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
7329: l_Input_PerType varchar2(90);
7330: l_action_mode varchar2(90);
7331: l_cur_rec per_all_people_f%rowtype;
7332:
7333: l_user_person_type per_person_types.user_person_type%type;
7334: l_user_sequence number(10);
7335: l_link_value number;
7336: l_error_mesg varchar2(2000);
7337: e_hire_applicant exception;
7869:
7870: l_dp_mode varchar2(40);
7871: l_if_end_dated varchar2(20);
7872: l_api_name hr_api_modules.module_name%type;
7873: l_user_person_type per_person_types.user_person_type%type;
7874: l_pay_basis_name per_pay_bases.name%type;
7875: l_organization_name hr_all_organization_units.name%type;
7876: l_location_code hr_locations_all.location_code%type;
7877: l_payroll_name pay_payrolls_f.payroll_name%type;
8865:
8866: --Added by DBANSAL to get the person type
8867: cursor csr_type (c_person_type_id in number) is
8868: select *
8869: from per_person_types
8870: where person_type_id = c_person_type_id
8871: and business_group_id = p_business_group_id;
8872:
8873: --$ Cursor to get APL assg details (no assg number)