eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_ENRT_PREM

Line 3925: (enrt_prem_id ben_enrt_prem.enrt_prem_id%type

3921: --
3922: TYPE cur_type IS REF CURSOR;
3923: --
3924: type g_efc_row is record
3925: (enrt_prem_id ben_enrt_prem.enrt_prem_id%type
3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type
3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type

Line 3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type

3922: TYPE cur_type IS REF CURSOR;
3923: --
3924: type g_efc_row is record
3925: (enrt_prem_id ben_enrt_prem.enrt_prem_id%type
3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type
3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type

Line 3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type

3923: --
3924: type g_efc_row is record
3925: (enrt_prem_id ben_enrt_prem.enrt_prem_id%type
3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type
3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type

Line 3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type

3924: type g_efc_row is record
3925: (enrt_prem_id ben_enrt_prem.enrt_prem_id%type
3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type
3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type
3932: ,creation_date ben_enrt_prem.creation_date%type

Line 3929: ,business_group_id ben_enrt_prem.business_group_id%type

3925: (enrt_prem_id ben_enrt_prem.enrt_prem_id%type
3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type
3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type
3932: ,creation_date ben_enrt_prem.creation_date%type
3933: ,object_version_number ben_enrt_prem.object_version_number%type

Line 3930: ,val ben_enrt_prem.val%type

3926: ,elig_per_elctbl_chc_id ben_enrt_prem.elig_per_elctbl_chc_id%type
3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type
3932: ,creation_date ben_enrt_prem.creation_date%type
3933: ,object_version_number ben_enrt_prem.object_version_number%type
3934: );

Line 3931: ,last_update_date ben_enrt_prem.last_update_date%type

3927: ,enrt_bnft_id ben_enrt_prem.enrt_bnft_id%type
3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type
3932: ,creation_date ben_enrt_prem.creation_date%type
3933: ,object_version_number ben_enrt_prem.object_version_number%type
3934: );
3935: --

Line 3932: ,creation_date ben_enrt_prem.creation_date%type

3928: ,actl_prem_id ben_enrt_prem.actl_prem_id%type
3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type
3932: ,creation_date ben_enrt_prem.creation_date%type
3933: ,object_version_number ben_enrt_prem.object_version_number%type
3934: );
3935: --
3936: c_efc_rows cur_type;

Line 3933: ,object_version_number ben_enrt_prem.object_version_number%type

3929: ,business_group_id ben_enrt_prem.business_group_id%type
3930: ,val ben_enrt_prem.val%type
3931: ,last_update_date ben_enrt_prem.last_update_date%type
3932: ,creation_date ben_enrt_prem.creation_date%type
3933: ,object_version_number ben_enrt_prem.object_version_number%type
3934: );
3935: --
3936: c_efc_rows cur_type;
3937: --

Line 4085: l_from_str := ' FROM ben_enrt_prem epr ';

4081: l_efc_batch := TRUE;
4082: --
4083: end if;
4084: --
4085: l_from_str := ' FROM ben_enrt_prem epr ';
4086: --
4087: l_where_str := ' where epr.val is not null ';
4088: --
4089: -- Check if we are restricting by business group

Line 4101: l_from_str := l_from_str||', ben_enrt_prem_efc efc ';

4097: -- Build in batch specific restrictions
4098: --
4099: if l_efc_batch then
4100: --
4101: l_from_str := l_from_str||', ben_enrt_prem_efc efc ';
4102: l_where_str := l_where_str||' and efc.enrt_prem_id = epr.enrt_prem_id '
4103: ||' and efc.efc_action_id = :action_id '
4104: ||' and epr.enrt_prem_id > :pk1 '
4105: ||' and mod(epr.enrt_prem_id, :total_workers) = :worker_id ';

Line 4404: update ben_enrt_prem epr

4400: if l_efc_batch
4401: and l_faterr_code is null
4402: then
4403: --
4404: update ben_enrt_prem epr
4405: set epr.val = l_val
4406: where epr.enrt_prem_id = l_efc_row.enrt_prem_id;
4407: --
4408: if p_validate then

Line 4481: (p_table_name => 'ben_enrt_prem'

4477: --
4478: -- Check that all rows have been converted or excluded
4479: --
4480: ben_efc_functions.conv_check
4481: (p_table_name => 'ben_enrt_prem'
4482: ,p_efctable_name => 'ben_enrt_prem_efc'
4483: ,p_tabwhere_clause => ' val is not null '
4484: --
4485: ,p_bgp_id => p_business_group_id

Line 4482: ,p_efctable_name => 'ben_enrt_prem_efc'

4478: -- Check that all rows have been converted or excluded
4479: --
4480: ben_efc_functions.conv_check
4481: (p_table_name => 'ben_enrt_prem'
4482: ,p_efctable_name => 'ben_enrt_prem_efc'
4483: ,p_tabwhere_clause => ' val is not null '
4484: --
4485: ,p_bgp_id => p_business_group_id
4486: ,p_action_id => p_action_id

Line 4763: from ben_enrt_prem epr,

4759: )
4760: is
4761: select epr.val,
4762: pil.per_in_ler_stat_cd
4763: from ben_enrt_prem epr,
4764: ben_per_in_ler pil,
4765: ben_elig_per_elctbl_chc epe
4766: where epr.actl_prem_id = c_actl_prem_id
4767: and epr.elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id