[Home] [Help]
2077: );
2078: --
2079: cursor csr_per_type(c_person_id number, c_effective_date date) is
2080: select ppt.system_person_type
2081: from per_person_types ppt,
2082: per_all_people_f ppf
2083: where ppf.person_id = c_person_id
2084: and ppf.person_type_id = ppt.person_type_id;
2085: --
2090: and date_from = c_date_from;
2091: --
2092: cursor csr_get_other(c_business_group_id number) is
2093: select ppt.person_type_id
2094: from per_person_types ppt
2095: where ppt.business_group_id = c_business_group_id
2096: and ppt.default_flag = 'Y'
2097: and ppt.active_flag = 'Y'
2098: and ppt.system_person_type = 'OTHER';
2152: update per_person_type_usages_f ptu
2153: set ptu.effective_start_date = p_cov_date_start
2154: where ptu.person_id = p_person_id
2155: and ptu.person_type_id in (select ppt.person_type_id
2156: from per_person_types ppt
2157: where ppt.system_person_type = 'OTHER');
2158: else
2159: hr_utility.set_location(l_proc,20);
2160: -- now change some of the fields before inserting precursor row
2392: cursor csr_get_person(c_contact_person_id number) is
2393: select ctr.person_id, min(nvl(ctr.date_start,hr_api.g_sot)) date_start
2394: from per_contact_relationships ctr
2395: ,per_person_type_usages_f ptu
2396: ,per_person_types ppt
2397: where ctr.contact_person_id = c_contact_person_id
2398: and ctr.person_id = ptu.person_id
2399: and ptu.person_type_id = ppt.person_type_id
2400: and ppt.system_person_type = 'EMP'