APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_MTCHG_RT_F

Line 3051: -- and tr.where_clause = l_BEN_MTCHG_RT_F

3047: from ben_copy_entity_results cpe,
3048: pqh_table_route tr
3049: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3050: and cpe.table_route_id = tr.table_route_id
3051: -- and tr.where_clause = l_BEN_MTCHG_RT_F
3052: and tr.table_alias = l_table_alias
3053: and cpe.number_of_copies = 1 -- ADDITION
3054: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
3055: order by information1, information2; --added for bug: 5151945

Line 3089: from BEN_MTCHG_RT_F MTR

3085: c_business_group_id number,
3086: c_new_pk_id number) is
3087: select
3088: MTR.mtchg_rt_id new_value
3089: from BEN_MTCHG_RT_F MTR
3090: where
3091: MTR.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
3092: nvl(MTR.COMP_LVL_FCTR_ID,-999) = nvl(l_COMP_LVL_FCTR_ID,-999) and
3093: MTR.business_group_id = c_business_group_id

Line 3101: from BEN_MTCHG_RT_F MTR1

3097: and effective_end_date ;
3098: --END TEMPIK
3099: /* TEMPIK
3100: and exists ( select null
3101: from BEN_MTCHG_RT_F MTR1
3102: where
3103: MTR1.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
3104: nvl(MTR1.COMP_LVL_FCTR_ID,-999) = nvl(l_COMP_LVL_FCTR_ID,-999) and
3105: MTR1.business_group_id = c_business_group_id

Line 3108: from BEN_MTCHG_RT_F MTR2

3104: nvl(MTR1.COMP_LVL_FCTR_ID,-999) = nvl(l_COMP_LVL_FCTR_ID,-999) and
3105: MTR1.business_group_id = c_business_group_id
3106: and MTR1.effective_start_date <= c_effective_start_date )
3107: and exists ( select null
3108: from BEN_MTCHG_RT_F MTR2
3109: where
3110: MTR2.ACTY_BASE_RT_ID = l_ACTY_BASE_RT_ID and
3111: nvl(MTR2.COMP_LVL_FCTR_ID,-999) = nvl(l_COMP_LVL_FCTR_ID,-999) and
3112: MTR2.business_group_id = c_business_group_id

Line 3261: (p_base_table_name => 'BEN_MTCHG_RT_F',

3257: fetch c_find_MTR_in_target into l_new_value ;
3258: if c_find_MTR_in_target%found then
3259: --TEMPIK
3260: l_dt_rec_found := dt_api.check_min_max_dates
3261: (p_base_table_name => 'BEN_MTCHG_RT_F',
3262: p_base_key_column => 'MTCHG_RT_ID',
3263: p_base_key_value => l_new_value,
3264: p_from_date => l_min_esd,
3265: p_to_date => l_max_eed );

Line 3329: hr_utility.set_location(' BEN_MTCHG_RT_F CREATE_MATCHING_RATES ',20);

3325: if l_first_rec and not l_update then
3326: -- UPD END
3327:
3328: -- Call Create routine.
3329: hr_utility.set_location(' BEN_MTCHG_RT_F CREATE_MATCHING_RATES ',20);
3330: BEN_MATCHING_RATES_API.CREATE_MATCHING_RATES(
3331: --
3332: P_VALIDATE => false
3333: ,P_EFFECTIVE_DATE => l_effective_date

Line 3407: hr_utility.set_location(' BEN_MTCHG_RT_F UPDATE_MATCHING_RATES ',30);

3403: else
3404: --
3405: -- Call Update routine for the pk_id created in prev run .
3406: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
3407: hr_utility.set_location(' BEN_MTCHG_RT_F UPDATE_MATCHING_RATES ',30);
3408:
3409: --UPD START
3410: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
3411: --