APPS.BEN_EFC_ADJUSTMENTS1 dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 2894: (bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%type

2890: --
2891: TYPE cur_type IS REF CURSOR;
2892: --
2893: type g_efc_row is record
2894: (bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%type
2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type
2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type

Line 2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type

2891: TYPE cur_type IS REF CURSOR;
2892: --
2893: type g_efc_row is record
2894: (bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%type
2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type
2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type

Line 2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type

2892: --
2893: type g_efc_row is record
2894: (bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%type
2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type
2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type

Line 2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type

2893: type g_efc_row is record
2894: (bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%type
2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type
2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type

Line 2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type

2894: (bnft_prvdd_ldgr_id ben_bnft_prvdd_ldgr_f.bnft_prvdd_ldgr_id%type
2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type
2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type

Line 2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type

2895: ,effective_start_date ben_bnft_prvdd_ldgr_f.effective_start_date%type
2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type

Line 2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type

2896: ,effective_end_date ben_bnft_prvdd_ldgr_f.effective_end_date%type
2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type

Line 2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type

2897: ,creation_date ben_bnft_prvdd_ldgr_f.creation_date%type
2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type

Line 2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type

2898: ,last_update_date ben_bnft_prvdd_ldgr_f.last_update_date%type
2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type

Line 2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type

2899: ,object_version_number ben_bnft_prvdd_ldgr_f.object_version_number%type
2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type

Line 2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type

2900: ,created_by ben_bnft_prvdd_ldgr_f.created_by%type
2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type

Line 2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type

2901: ,last_updated_by ben_bnft_prvdd_ldgr_f.last_updated_by%type
2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type

Line 2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type

2902: ,used_val ben_bnft_prvdd_ldgr_f.used_val%type
2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type

Line 2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type

2903: ,FRFTD_VAL ben_bnft_prvdd_ldgr_f.FRFTD_VAL%type
2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type

Line 2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type

2904: ,PRVDD_VAL ben_bnft_prvdd_ldgr_f.PRVDD_VAL%type
2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type
2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type

Line 2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type

2905: ,RLD_UP_VAL ben_bnft_prvdd_ldgr_f.RLD_UP_VAL%type
2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type
2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2913: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type

Line 2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type

2906: ,CASH_RECD_VAL ben_bnft_prvdd_ldgr_f.CASH_RECD_VAL%type
2907: ,business_group_id ben_bnft_prvdd_ldgr_f.business_group_id%type
2908: ,bnft_prvdr_pool_id ben_bnft_prvdd_ldgr_f.bnft_prvdr_pool_id%type
2909: ,acty_base_rt_id ben_bnft_prvdd_ldgr_f.acty_base_rt_id%type
2910: ,prtt_enrt_rslt_id ben_bnft_prvdd_ldgr_f.prtt_enrt_rslt_id%type
2911: ,person_id ben_per_in_ler.person_id%type
2912: ,per_in_ler_id ben_per_in_ler.per_in_ler_id%type
2913: ,lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type
2914: );

Line 2983: ben_bnft_prvdd_ldgr_f bpl,

2979: select ecr.prtt_rt_val_id,
2980: ecr.ELIG_PER_ELCTBL_CHC_ID
2981: from ben_enrt_bnft enb,
2982: ben_enrt_rt ecr,
2983: ben_bnft_prvdd_ldgr_f bpl,
2984: ben_elig_per_elctbl_chc epe
2985: where ecr.DECR_BNFT_PRVDR_POOL_ID = bpl.BNFT_PRVDR_POOL_ID
2986: and ecr.acty_base_rt_id = bpl.acty_base_rt_id
2987: and ecr.enrt_bnft_id = enb.enrt_bnft_id

Line 2996: ben_bnft_prvdd_ldgr_f bpl,

2992: union
2993: select ecr.prtt_rt_val_id,
2994: ecr.ELIG_PER_ELCTBL_CHC_ID
2995: from ben_enrt_rt ecr,
2996: ben_bnft_prvdd_ldgr_f bpl,
2997: ben_elig_per_elctbl_chc epe
2998: where ecr.DECR_BNFT_PRVDR_POOL_ID = bpl.BNFT_PRVDR_POOL_ID
2999: and ecr.acty_base_rt_id = bpl.acty_base_rt_id
3000: and ecr.ELIG_PER_ELCTBL_CHC_ID = epe.ELIG_PER_ELCTBL_CHC_ID

Line 3026: from ben_bnft_prvdd_ldgr_f bpl

3022: bpl.last_update_date,
3023: bpl.created_by,
3024: bpl.last_updated_by,
3025: bpl.object_version_number
3026: from ben_bnft_prvdd_ldgr_f bpl
3027: where bpl.bnft_prvdd_ldgr_id = c_bpl_id
3028: and c_eff_date
3029: between bpl.effective_start_date and bpl.effective_end_date;
3030: --

Line 3131: l_from_str := ' FROM ben_bnft_prvdd_ldgr_f bpl, '

3127: l_efc_batch := TRUE;
3128: --
3129: end if;
3130: --
3131: l_from_str := ' FROM ben_bnft_prvdd_ldgr_f bpl, '
3132: ||' ben_per_in_ler pil, '
3133: ||' per_all_people_f per ';
3134: --
3135: l_where_str := ' where bpl.per_in_ler_id = pil.per_in_ler_id '

Line 3164: l_from_str := l_from_str||', ben_bnft_prvdd_ldgr_f_efc efc ';

3160: -- Build in batch specific restrictions
3161: --
3162: if l_efc_batch then
3163: --
3164: l_from_str := l_from_str||', ben_bnft_prvdd_ldgr_f_efc efc ';
3165: l_where_str := l_where_str||' and efc.bnft_prvdd_ldgr_id = bpl.bnft_prvdd_ldgr_id '
3166: ||' and efc.efc_action_id = :action_id '
3167: ||' and bpl.bnft_prvdd_ldgr_id > :pk1 '
3168: ||' and mod(bpl.bnft_prvdd_ldgr_id, :total_workers) = :worker_id ';

Line 3570: update ben_bnft_prvdd_ldgr_f bpl

3566: --
3567: if l_efc_batch and l_faterr_code is null
3568: then
3569: --
3570: update ben_bnft_prvdd_ldgr_f bpl
3571: set bpl.used_val = l_bpl_used_val,
3572: bpl.prvdd_val = l_bpl_prvdd_val,
3573: bpl.cash_recd_val = l_bpl_cash_recd_val,
3574: bpl.frftd_val = l_bpl_frftd_val,

Line 3662: (p_table_name => 'ben_bnft_prvdd_ldgr_f'

3658: --
3659: -- Check that all rows have been converted or excluded
3660: --
3661: ben_efc_functions.conv_check
3662: (p_table_name => 'ben_bnft_prvdd_ldgr_f'
3663: ,p_efctable_name => 'ben_bnft_prvdd_ldgr_f_efc'
3664: ,p_tabwhere_clause => ' (used_val is not null '
3665: ||' or FRFTD_VAL is not null '
3666: ||' or PRVDD_VAL is not null '

Line 3663: ,p_efctable_name => 'ben_bnft_prvdd_ldgr_f_efc'

3659: -- Check that all rows have been converted or excluded
3660: --
3661: ben_efc_functions.conv_check
3662: (p_table_name => 'ben_bnft_prvdd_ldgr_f'
3663: ,p_efctable_name => 'ben_bnft_prvdd_ldgr_f_efc'
3664: ,p_tabwhere_clause => ' (used_val is not null '
3665: ||' or FRFTD_VAL is not null '
3666: ||' or PRVDD_VAL is not null '
3667: ||' or RLD_UP_VAL is not null '