APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_VRBL_MTCHG_RT_F

Line 11608: -- and tr.where_clause = l_BEN_VRBL_MTCHG_RT_F

11604: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
11605: pqh_table_route tr
11606: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11607: and cpe.table_route_id = tr.table_route_id
11608: -- and tr.where_clause = l_BEN_VRBL_MTCHG_RT_F
11609: and tr.table_alias = l_table_alias
11610: and cpe.number_of_copies = 1 -- ADDITION
11611: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11612: order by information1, information2; --added for bug: 5151945

Line 11646: from BEN_VRBL_MTCHG_RT_F VMR

11642: c_business_group_id number,
11643: c_new_pk_id number) is
11644: select
11645: VMR.vrbl_mtchg_rt_id new_value
11646: from BEN_VRBL_MTCHG_RT_F VMR
11647: where
11648: VMR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11649: nvl(VMR.MTCHG_RT_CALC_RL, -999) = nvl(l_MTCHG_RT_CALC_RL, -999) and
11650: VMR.business_group_id = c_business_group_id

Line 11658: from BEN_VRBL_MTCHG_RT_F VMR1

11654: and effective_end_date ;
11655: --END TEMPIK
11656: /*TEMPIK
11657: and exists ( select null
11658: from BEN_VRBL_MTCHG_RT_F VMR1
11659: where
11660: VMR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11661: nvl(VMR1.MTCHG_RT_CALC_RL, -999) = nvl(l_MTCHG_RT_CALC_RL, -999) and
11662: VMR1.business_group_id = c_business_group_id

Line 11665: from BEN_VRBL_MTCHG_RT_F VMR2

11661: nvl(VMR1.MTCHG_RT_CALC_RL, -999) = nvl(l_MTCHG_RT_CALC_RL, -999) and
11662: VMR1.business_group_id = c_business_group_id
11663: and VMR1.effective_start_date <= c_effective_start_date )
11664: and exists ( select null
11665: from BEN_VRBL_MTCHG_RT_F VMR2
11666: where
11667: VMR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
11668: nvl(VMR2.MTCHG_RT_CALC_RL, -999) = nvl(l_MTCHG_RT_CALC_RL, -999) and
11669: VMR2.business_group_id = c_business_group_id

Line 11801: (p_base_table_name => 'BEN_VRBL_MTCHG_RT_F',

11797: if c_find_VMR_in_target%found then
11798: --
11799: --TEMPIK
11800: l_dt_rec_found := dt_api.check_min_max_dates
11801: (p_base_table_name => 'BEN_VRBL_MTCHG_RT_F',
11802: p_base_key_column => 'VRBL_MTCHG_RT_ID',
11803: p_base_key_value => l_new_value,
11804: p_from_date => l_min_esd,
11805: p_to_date => l_max_eed );

Line 11859: hr_utility.set_location(' BEN_VRBL_MTCHG_RT_F CREATE_VRBL_MATCHING_RATE ',20);

11855: end if;
11856:
11857: if l_first_rec and not l_update then
11858: -- Call Create routine.
11859: hr_utility.set_location(' BEN_VRBL_MTCHG_RT_F CREATE_VRBL_MATCHING_RATE ',20);
11860: BEN_VRBL_MATCHING_RATE_API.CREATE_VRBL_MATCHING_RATE(
11861: --
11862: P_VALIDATE => false
11863: ,P_EFFECTIVE_DATE => l_effective_date

Line 11961: hr_utility.set_location(' BEN_VRBL_MTCHG_RT_F UPDATE_VRBL_MATCHING_RATE ',30);

11957: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
11958: --
11959: IF l_update OR l_dml_operation <> 'UPDATE' THEN
11960: --UPD END
11961: hr_utility.set_location(' BEN_VRBL_MTCHG_RT_F UPDATE_VRBL_MATCHING_RATE ',30);
11962: BEN_VRBL_MATCHING_RATE_API.UPDATE_VRBL_MATCHING_RATE(
11963: --
11964: P_VALIDATE => false
11965: ,P_EFFECTIVE_DATE => l_effective_date