APPS.BEN_PRTT_RT_VAL_API dependencies on BEN_ENRT_RT

Line 289: from ben_enrt_rt_ctfn erc

285: -- LGE : Rate certification.
286: --
287: cursor c_enrt_ctfn(p_enrt_rt_id in number) is
288: select erc.*
289: from ben_enrt_rt_ctfn erc
290: where enrt_rt_id = p_enrt_rt_id
291: and business_group_id = p_business_group_id;
292: --
293: -- LGE : Check whether the rate is non recurring and attached to

Line 537: -- only update the ben_enrt_rt table to point to the inserted prtt_rt_val

533: );
534: --
535: if p_enrt_rt_id is not null then
536: --
537: -- only update the ben_enrt_rt table to point to the inserted prtt_rt_val
538: -- row if the rate val row is not being inserted as a void or backed out
539: -- row. if the rate end date is less than the rate start date, the row
540: -- will be voided in the pre-insert and pre-update in the rhi.
541: --

Line 551: (p_base_table_name => 'ben_enrt_rt',

547: -- Get the object version number for the update
548: --
549: l_enrt_rt_ovn:=
550: dt_api.get_object_version_number
551: (p_base_table_name => 'ben_enrt_rt',
552: p_base_key_column => 'enrt_rt_id',
553: p_base_key_value => p_enrt_rt_id)-1;
554:
555: ben_enrollment_rate_api.update_enrollment_rate(

Line 1559: from ben_enrt_rt

1555: --
1556: cursor c_enrt_rt (p_prtt_rt_val_id number) is
1557: select enrt_rt_id,
1558: object_version_number
1559: from ben_enrt_rt
1560: where prtt_rt_val_id = p_prtt_rt_val_id;
1561: --
1562: l_proc varchar2(72); -- := g_package||'delete_prtt_rt_val';
1563: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

Line 1653: (p_base_table_name => 'ben_enrt_rt',

1649: end if;
1650: /*
1651: l_enrt_rt_ovn:=
1652: dt_api.get_object_version_number
1653: (p_base_table_name => 'ben_enrt_rt',
1654: p_base_key_column => 'enrt_rt_id',
1655: p_base_key_value => p_enrt_rt_id)-1;
1656: --
1657: */