DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on BEN_PTNL_LER_FOR_PER

Line 95: of ben_ptnl_ler_for_per_api.creat

91: handle temporal life events
92: correctly so we only create
93: them once.
94: 07-Jul-98 J Mohapatra 110.29 Added batch who cols to call
95: of ben_ptnl_ler_for_per_api.creat
96: e_ptnl_ler_for_per
97: 30-Jul-98 G Perry 110.30 Fixed error in calculate_percent
98: _fulltime procedure.
99: 24-Aug-98 G Perry 110.31 Fixed 'STTDCOMP' for calulating

Line 1840: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;

1836: AND ler.effective_end_date;
1837: --
1838: -- Create local variables required for API call
1839: --
1840: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
1841: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
1842: --
1843: l_package VARCHAR2(80) := g_package || '.create_ptl_ler';
1844: --

Line 1841: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

1837: --
1838: -- Create local variables required for API call
1839: --
1840: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;
1841: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;
1842: --
1843: l_package VARCHAR2(80) := g_package || '.create_ptl_ler';
1844: --
1845: l_ler_name VARCHAR2(240);

Line 1926: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf(p_validate=> FALSE

1922: benutils.write(p_text=> fnd_message.get);
1923: --
1924: if not p_calculate_only_mode then
1925: --
1926: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf(p_validate=> FALSE
1927: ,p_ptnl_ler_for_per_id => l_ptnl_ler_for_per_id
1928: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1929: ,p_ptnl_ler_for_per_stat_cd => 'DTCTD'
1930: ,p_ler_id => l_ler_id

Line 1986: FROM ben_ptnl_ler_for_per pil

1982: -- life event as it could be someone was running in the past or future.
1983: --
1984: CURSOR c1 IS
1985: SELECT NULL
1986: FROM ben_ptnl_ler_for_per pil
1987: WHERE pil.person_id = p_person_id
1988: AND pil.ler_id = l_ler_id
1989: AND pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
1990: --