APPS.BEN_PRTT_RT_VAL_API dependencies on BEN_ENRT_RT

Line 290: from ben_enrt_rt_ctfn erc

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

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

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

Line 552: (p_base_table_name => 'ben_enrt_rt',

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

Line 1610: from ben_enrt_rt

1606: --
1607: cursor c_enrt_rt (p_prtt_rt_val_id number) is
1608: select enrt_rt_id,
1609: object_version_number
1610: from ben_enrt_rt
1611: where prtt_rt_val_id = p_prtt_rt_val_id;
1612: --
1613: l_proc varchar2(72); -- := g_package||'delete_prtt_rt_val';
1614: l_object_version_number ben_prtt_rt_val.object_version_number%TYPE;

Line 1704: (p_base_table_name => 'ben_enrt_rt',

1700: end if;
1701: /*
1702: l_enrt_rt_ovn:=
1703: dt_api.get_object_version_number
1704: (p_base_table_name => 'ben_enrt_rt',
1705: p_base_key_column => 'enrt_rt_id',
1706: p_base_key_value => p_enrt_rt_id)-1;
1707: --
1708: */