[Home] [Help]
225: ,ppf.employee_number
226: ,ppt.person_type_id
227: ,ppf.person_id
228: from per_all_people_f ppf
229: ,per_person_types ppt
230: where ppt.person_type_id = ppf.person_type_id
231: and ppf.business_group_id = c_bg_grp_id
232: and ppt.business_group_id = ppf.business_group_id
233: and ppt.active_flag = 'Y'
245: ,ppt.active_flag
246: ,ppt.system_person_type
247: ,ppt.user_person_type
248: from per_person_type_usages_f ptu
249: ,per_person_types ppt
250: where ptu.person_id = c_person_id
251: and ppt.business_group_id = c_business_group_id
252: and ppt.person_type_id = ptu.person_type_id
253: and c_effective_date between ptu.effective_start_date
266: select ptu.person_type_id
267: ,ppt.system_person_type
268: ,ppt.user_person_type
269: from per_person_type_usages_f ptu
270: ,per_person_types ppt
271: where ptu.person_id = c_person_id
272: and ppt.person_type_id = ptu.person_type_id
273: and ppt.business_group_id = c_business_group_id
274: and ptu.effective_start_date > c_effective_date
344: --
345: cursor csr_per_type(c_person_type_id number
346: ,c_business_group_id in number) is
347: select ppt.user_person_type
348: from per_person_types ppt
349: where ppt.person_type_id = c_person_type_id
350: and ppt.business_group_id = c_business_group_id;
351: --
352: -- Cursor to get the Grade Name
2044: ) is
2045:
2046: cursor csr_type (c_person_type_id in number) is
2047: select *
2048: from per_person_types
2049: where person_type_id = c_person_type_id
2050: and business_group_id = p_business_group_id;
2051:
2052: l_pty_rec csr_type%rowtype;
2066: ,ppf.person_id
2067: ,ppf.object_version_number
2068: from per_all_people_f ppf
2069: ,per_person_type_usages_f ptu
2070: ,per_person_types ppt
2071: where ptu.person_type_id = ppf.person_type_id
2072: and ppt.person_type_id = ptu.person_type_id
2073: and ppt.business_group_id = ppf.business_group_id
2074: and ppf.business_group_id = c_bg_grp_id
2088: e_active_empcwk exception;
2089: e_active_apl exception;
2090: l_person_id per_all_people_f.person_id%type;
2091: l_party_id per_all_people_f.person_id%type;
2092: l_user_person_type per_person_types.user_person_type%TYPE;
2093: l_effective_date date;
2094: l_proc_name constant varchar2(150):= g_pkg ||'Chk_Person_InHR';
2095: begin
2096: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6925: l_Input_PerType varchar2(90);
6926: l_action_mode varchar2(90);
6927: l_cur_rec per_all_people_f%rowtype;
6928:
6929: l_user_person_type per_person_types.user_person_type%type;
6930: l_user_sequence number(10);
6931: l_link_value number;
6932: l_error_mesg varchar2(2000);
6933: e_hire_applicant exception;
7465:
7466: l_dp_mode varchar2(40);
7467: l_if_end_dated varchar2(20);
7468: l_api_name hr_api_modules.module_name%type;
7469: l_user_person_type per_person_types.user_person_type%type;
7470: l_pay_basis_name per_pay_bases.name%type;
7471: l_organization_name hr_all_organization_units.name%type;
7472: l_location_code hr_locations_all.location_code%type;
7473: l_payroll_name pay_payrolls_f.payroll_name%type;
8461:
8462: --Added by DBANSAL to get the person type
8463: cursor csr_type (c_person_type_id in number) is
8464: select *
8465: from per_person_types
8466: where person_type_id = c_person_type_id
8467: and business_group_id = p_business_group_id;
8468:
8469: --$ Cursor to get APL assg details (no assg number)