APPS.BEN_WHATIF_ELIG dependencies on BEN_PER_BNFTS_BAL_F

Line 3130: select * from ben_per_bnfts_bal_f

3126: ,p_effective_date in date
3127: )is
3128: --
3129: cursor c_bnfts_bal is
3130: select * from ben_per_bnfts_bal_f
3131: where person_id = p_person_id and
3132: bnfts_bal_id = p_BNFTS_BAL_ID and
3133: business_group_id = p_business_group_id and
3134: p_effective_date between effective_start_date

Line 3143: per_bnft_bal_rec ben_per_bnfts_bal_f%rowtype;

3139: l_effective_end_date date;
3140: l_object_version_number number;
3141: l_upd_mode varchar2(50);
3142: --
3143: per_bnft_bal_rec ben_per_bnfts_bal_f%rowtype;
3144: --
3145: begin
3146: --
3147: hr_utility.set_location(' Entering: WATIF_PER_BNFTS_BAL_F_API' , 10);

Line 3222: p_base_table_name => 'BEN_PER_BNFTS_BAL_F',

3218: else
3219: --
3220: Get_DT_Upd_Mode
3221: (p_effective_date => p_effective_date,
3222: p_base_table_name => 'BEN_PER_BNFTS_BAL_F',
3223: p_base_key_column => 'PER_BNFTS_BAL_ID',
3224: p_base_key_value => per_bnft_bal_rec.per_bnfts_bal_id,
3225: p_mode => l_upd_mode);
3226: --