APPS.BEN_CCM_BUS dependencies on BEN_OIPL_F

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 2069: (p_base_table_name => 'ben_oipl_f',

2065: p_argument_value => p_validation_end_date);
2066: --
2067: If ((nvl(p_oipl_id, hr_api.g_number) <> hr_api.g_number) and
2068: NOT (dt_api.check_min_max_dates
2069: (p_base_table_name => 'ben_oipl_f',
2070: p_base_key_column => 'oipl_id',
2071: p_base_key_value => p_oipl_id,
2072: p_from_date => p_validation_start_date,
2073: p_to_date => p_validation_end_date))) Then

Line 2074: l_table_name := 'ben_oipl_f';

2070: p_base_key_column => 'oipl_id',
2071: p_base_key_value => p_oipl_id,
2072: p_from_date => p_validation_start_date,
2073: p_to_date => p_validation_end_date))) Then
2074: l_table_name := 'ben_oipl_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