APPS.BEN_COP_BUS dependencies on BEN_PL_F

Line 1660: from ben_pl_f pl

1656: l_dummy varchar2(1);
1657: --
1658: cursor c1 is
1659: select null
1660: from ben_pl_f pl
1661: where pl.pl_id = p_pl_id
1662: and pl.enrt_mthd_cd = 'A'
1663: and p_effective_date between pl.effective_start_date
1664: and pl.effective_end_date

Line 1871: from ben_pl_f a

1867: l_dummy varchar2(1);
1868: --
1869: cursor c1 is
1870: select null
1871: from ben_pl_f a
1872: where a.business_group_id +0 = p_business_group_id
1873: and a.actl_prem_id = p_actl_prem_id
1874: and p_effective_date
1875: between a.effective_start_date

Line 1966: FROM ben_pl_f pln

1962: --
1963: -- Start of CAGR band aid.
1964: --
1965: AND NOT EXISTS(SELECT 'x'
1966: FROM ben_pl_f pln
1967: , ben_pl_typ_f ptp
1968: WHERE pln.pl_id = p_pl_id
1969: AND pln.pl_typ_id = ptp.pl_typ_id
1970: AND pln.business_group_id = p_business_group_id

Line 2216: (p_base_table_name => 'ben_pl_f',

2212: Raise l_integrity_error;
2213: End If;
2214: If ((nvl(p_pl_id, hr_api.g_number) <> hr_api.g_number) and
2215: NOT (dt_api.check_min_max_dates
2216: (p_base_table_name => 'ben_pl_f',
2217: p_base_key_column => 'pl_id',
2218: p_base_key_value => p_pl_id,
2219: p_from_date => p_validation_start_date,
2220: p_to_date => p_validation_end_date))) Then

Line 2221: l_table_name := 'ben_pl_f';

2217: p_base_key_column => 'pl_id',
2218: p_base_key_value => p_pl_id,
2219: p_from_date => p_validation_start_date,
2220: p_to_date => p_validation_end_date))) Then
2221: l_table_name := 'ben_pl_f';
2222: Raise l_integrity_error;
2223: End If;
2224: If ((nvl(p_opt_id, hr_api.g_number) <> hr_api.g_number) and
2225: NOT (dt_api.check_min_max_dates