eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_BENEFICIARY_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 1741: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

1737: l_proc varchar2(72) := g_package||'add_usage';
1738: --
1739: l_person_type_id number(15);
1740: l_person_type_usage_id number(15);
1741: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1742: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1743: --
1744: l1_person_type_usage_id number(15);
1745: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

Line 1742: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

1738: --
1739: l_person_type_id number(15);
1740: l_person_type_usage_id number(15);
1741: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1742: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1743: --
1744: l1_person_type_usage_id number(15);
1745: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1746: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

Line 1745: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;

1741: l_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1742: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1743: --
1744: l1_person_type_usage_id number(15);
1745: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1746: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1747: --
1748: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1749: l_enrt_cvg_strt_dt date;

Line 1746: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;

1742: l_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1743: --
1744: l1_person_type_usage_id number(15);
1745: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1746: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1747: --
1748: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1749: l_enrt_cvg_strt_dt date;
1750: l_dsg_strt_dt date;

Line 1748: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;

1744: l1_person_type_usage_id number(15);
1745: l1_effective_start_date per_person_type_usages_f.effective_start_date%TYPE;
1746: l1_effective_end_date per_person_type_usages_f.effective_end_date%TYPE;
1747: --
1748: l_object_version_number per_person_type_usages_f.object_version_number%TYPE;
1749: l_enrt_cvg_strt_dt date;
1750: l_dsg_strt_dt date;
1751: --
1752: --

Line 1774: from per_person_type_usages_f a

1770: cursor find_ptu_ovlp_segments_c is
1771: select a.effective_start_date,
1772: a.effective_end_date,
1773: a.person_type_usage_id
1774: from per_person_type_usages_f a
1775: where a.person_id = p_bnf_person_id
1776: and a.person_type_id = l_person_type_id
1777: -- and a.effective_start_date <= hr_api.g_date
1778: and a.effective_end_date >= l_dsg_strt_dt

Line 1850: update per_person_type_usages_f

1846: null;
1847: elsif l_effective_start_date <= l_dsg_strt_dt and
1848: l_effective_end_date < hr_api.g_date
1849: then
1850: update per_person_type_usages_f
1851: set effective_end_date = hr_api.g_date
1852: where person_type_usage_id = l_person_type_usage_id;
1853: elsif l_effective_start_date > l_dsg_strt_dt and
1854: l_effective_end_date = hr_api.g_date then

Line 1856: update per_person_type_usages_f

1852: where person_type_usage_id = l_person_type_usage_id;
1853: elsif l_effective_start_date > l_dsg_strt_dt and
1854: l_effective_end_date = hr_api.g_date then
1855: --
1856: update per_person_type_usages_f
1857: set effective_start_date = l_dsg_strt_dt
1858: where person_type_usage_id = l_person_type_usage_id;
1859: --
1860: elsif l_effective_start_date > l_dsg_strt_dt and

Line 1863: update per_person_type_usages_f

1859: --
1860: elsif l_effective_start_date > l_dsg_strt_dt and
1861: l_effective_end_date < hr_api.g_date then
1862: --
1863: update per_person_type_usages_f
1864: set effective_start_date = l_dsg_strt_dt,
1865: effective_end_date = hr_api.g_date
1866: where person_type_usage_id = l_person_type_usage_id;
1867: --

Line 1939: from per_person_type_usages_f a,

1935: a.object_version_number,
1936: a.effective_end_date
1937: -- bug 5668052
1938: ,a.effective_start_date
1939: from per_person_type_usages_f a,
1940: per_person_types b
1941: where a.person_id = l_bnf_person_id
1942: and a.person_type_id = b.person_type_id
1943: and b.system_person_type = 'BNF'