APPS.BEN_CCM_BUS dependencies on BEN_PL_F

Line 1827: from ben_pl_f pl

1823: and p_effective_date between effective_start_date
1824: and effective_end_date;
1825:
1826: cursor c2 is select 'x'
1827: from ben_pl_f pl
1828: Where pl.pl_id = p_pl_id
1829: and pl.dflt_to_asn_pndg_ctfn_cd like '%NL%' -- Next Lower
1830: and pl.business_group_id = p_business_group_id
1831: and p_effective_date between pl.effective_start_date

Line 1936: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;

1932: is
1933: --
1934: l_proc varchar2(72) := g_package||'.chk_plan_not_savings';
1935: l_dummy varchar2(1);
1936: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;
1937: --
1938: cursor c_pln is
1939: select null
1940: from ben_pl_f

Line 1940: from ben_pl_f

1936: l_svgs_pl_flag ben_pl_f.svgs_pl_flag%type;
1937: --
1938: cursor c_pln is
1939: select null
1940: from ben_pl_f
1941: Where pl_id = p_pl_id
1942: and svgs_pl_flag = 'Y'
1943: and effective_start_date <= p_validation_end_date
1944: and effective_end_date >= p_validation_start_date;

Line 1948: from ben_pl_f pln, ben_oipl_f oipl

1944: and effective_end_date >= p_validation_start_date;
1945:
1946: cursor c_oipl is
1947: select null
1948: from ben_pl_f pln, ben_oipl_f oipl
1949: Where oipl_id = p_oipl_id
1950: and pln.pl_id = oipl.pl_id
1951: and pln.svgs_pl_flag = 'Y'
1952: and pln.effective_start_date <= p_validation_end_date

Line 2079: (p_base_table_name => 'ben_pl_f',

2075: Raise l_integrity_error;
2076: End If;
2077: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2078: NOT (dt_api.check_min_max_dates
2079: (p_base_table_name => 'ben_pl_f',
2080: p_base_key_column => 'pl_id',
2081: p_base_key_value => p_pl_id,
2082: p_from_date => p_validation_start_date,
2083: p_to_date => p_validation_end_date))) Then

Line 2084: l_table_name := 'ben_pl_f';

2080: p_base_key_column => 'pl_id',
2081: p_base_key_value => p_pl_id,
2082: p_from_date => p_validation_start_date,
2083: p_to_date => p_validation_end_date))) Then
2084: l_table_name := 'ben_pl_f';
2085: Raise l_integrity_error;
2086: End If;
2087: If ((nvl(p_plip_id, hr_api.g_number) <> hr_api.g_number) and
2088: NOT (dt_api.check_min_max_dates