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 1839: l_ptnl_ler_for_per_id ben_ptnl_ler_for_per.ptnl_ler_for_per_id%TYPE;

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

Line 1840: l_object_version_number ben_ptnl_ler_for_per.object_version_number%TYPE;

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

Line 1925: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf(p_validate=> FALSE

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

Line 1985: FROM ben_ptnl_ler_for_per pil

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