APPS.BEN_LEN_BUS dependencies on BEN_POPL_ENRT_TYP_CYCL_F

Line 1337: ben_popl_enrt_typ_cycl_f pet,

1333: is
1334: cursor c_duplicate_ler is
1335: select 1
1336: from
1337: ben_popl_enrt_typ_cycl_f pet,
1338: ben_pl_f pln,
1339: ben_lee_rsn_f len1,
1340: ben_popl_enrt_typ_cycl_f pet1,
1341: ben_pl_f pln1

Line 1340: ben_popl_enrt_typ_cycl_f pet1,

1336: from
1337: ben_popl_enrt_typ_cycl_f pet,
1338: ben_pl_f pln,
1339: ben_lee_rsn_f len1,
1340: ben_popl_enrt_typ_cycl_f pet1,
1341: ben_pl_f pln1
1342: where
1343: pet.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
1344: and p_effective_date between pet.effective_start_date

Line 1426: ,ben_popl_enrt_typ_cycl_f pet

1422: --
1423: cursor c_pl_cd is
1424: select pln.pl_cd
1425: from ben_pl_f pln
1426: ,ben_popl_enrt_typ_cycl_f pet
1427: where pet.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id
1428: and pet.pl_id = pln.pl_id
1429: and pln.business_group_id = p_business_group_id
1430: and pet.business_group_id = pln.business_group_id

Line 1607: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',

1603: p_argument_value => p_validation_end_date);
1604: --
1605: If ((nvl(p_popl_enrt_typ_cycl_id, hr_api.g_number) <> hr_api.g_number) and
1606: NOT (dt_api.check_min_max_dates
1607: (p_base_table_name => 'ben_popl_enrt_typ_cycl_f',
1608: p_base_key_column => 'popl_enrt_typ_cycl_id',
1609: p_base_key_value => p_popl_enrt_typ_cycl_id,
1610: p_from_date => p_validation_start_date,
1611: p_to_date => p_validation_end_date))) Then

Line 1612: l_table_name := 'ben_popl_enrt_typ_cycl_f';

1608: p_base_key_column => 'popl_enrt_typ_cycl_id',
1609: p_base_key_value => p_popl_enrt_typ_cycl_id,
1610: p_from_date => p_validation_start_date,
1611: p_to_date => p_validation_end_date))) Then
1612: l_table_name := 'ben_popl_enrt_typ_cycl_f';
1613: Raise l_integrity_error;
1614: End If;
1615: --
1616: End If;