[Home] [Help]
126: g_cache_all_ass_rec cache is not build correctly. Added code
127: to build the cache correctly.
128: 120.0.12000000.10 18-Apr-12 usaraswa Bug 13965664 Modified procedure set_typ_object to cache the date
129: of per_all_people_f when there is no data present in
130: per_person_type_usages_f for the person_id passed.
131: -----------------------------------------------------------------------------
132: */
133: --
134: g_package varchar2(30) := 'ben_person_object.';
1571: ppt.person_type_id,
1572: ppt.user_person_type,
1573: ppt.system_person_type,
1574: decode(ppt.system_person_type,'EMP',1,2)
1575: from per_person_type_usages_f per,
1576: per_person_types ppt
1577: where per.person_id = p_person_id
1578: and p_effective_date
1579: between per.effective_start_date
1580: and per.effective_end_date
1581: and per.person_type_id = ppt.person_type_id
1582: --Bug 13965664 start
1583: -- Considering per_all_people_f when there is no record at all in
1584: -- per_person_type_usages_f
1585: union
1586: select ppf.person_id,
1587: ppt.person_type_id,
1588: ppt.user_person_type,
1595: between ppf.effective_start_date
1596: and ppf.effective_end_date
1597: and ppf.person_type_id = ppt.person_type_id
1598: and not exists
1599: (select null from per_person_type_usages_f where person_id = p_person_id)
1600: --Bug 13965664 end
1601:
1602: --
1603: -- This person_type_id is the original person type id. It is possible that
1600: --Bug 13965664 end
1601:
1602: --
1603: -- This person_type_id is the original person type id. It is possible that
1604: -- this person type id may not exist in per_person_type_usages_f. So this
1605: -- data should not be used for profiles evaluation.
1606: --
1607: /* union
1608: select ppf.person_id,