APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_VRBL_RT_PRFL_RL_F

Line 19523: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_RL_F

19519: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
19520: pqh_table_route tr
19521: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
19522: and cpe.table_route_id = tr.table_route_id
19523: -- and tr.where_clause = l_BEN_VRBL_RT_PRFL_RL_F
19524: and tr.table_alias = l_table_alias
19525: and cpe.number_of_copies = 1 -- ADDITION
19526: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
19527: order by information1, information2; --added for bug: 5151945

Line 19561: from BEN_VRBL_RT_PRFL_RL_F VPR

19557: c_business_group_id number,
19558: c_new_pk_id number) is
19559: select
19560: VPR.vrbl_rt_prfl_rl_id new_value
19561: from BEN_VRBL_RT_PRFL_RL_F VPR
19562: where
19563: nvl(VPR.FORMULA_ID,-999) = nvl(l_FORMULA_ID,-999) and
19564: VPR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19565: VPR.business_group_id = c_business_group_id

Line 19573: from BEN_VRBL_RT_PRFL_RL_F VPR1

19569: and effective_end_date ;
19570: --END TEMPIK
19571: /*TEMPIK
19572: and exists ( select null
19573: from BEN_VRBL_RT_PRFL_RL_F VPR1
19574: where
19575: nvl(VPR1.FORMULA_ID,-999) = nvl(l_FORMULA_ID,-999) and
19576: VPR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19577: VPR1.business_group_id = c_business_group_id

Line 19580: from BEN_VRBL_RT_PRFL_RL_F VPR2

19576: VPR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19577: VPR1.business_group_id = c_business_group_id
19578: and VPR1.effective_start_date <= c_effective_start_date )
19579: and exists ( select null
19580: from BEN_VRBL_RT_PRFL_RL_F VPR2
19581: where
19582: nvl(VPR2.FORMULA_ID,-999) = nvl(l_FORMULA_ID,-999) and
19583: VPR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
19584: VPR2.business_group_id = c_business_group_id

Line 19715: (p_base_table_name => 'BEN_VRBL_RT_PRFL_RL_F',

19711: fetch c_find_VPR_in_target into l_new_value ;
19712: if c_find_VPR_in_target%found then
19713: --TEMPIK
19714: l_dt_rec_found := dt_api.check_min_max_dates
19715: (p_base_table_name => 'BEN_VRBL_RT_PRFL_RL_F',
19716: p_base_key_column => 'VRBL_RT_PRFL_RL_ID',
19717: p_base_key_value => l_new_value,
19718: p_from_date => l_min_esd,
19719: p_to_date => l_max_eed );

Line 19774: hr_utility.set_location(' BEN_VRBL_RT_PRFL_RL_F CREATE_VRBL_RT_PRFL_RULE ',20);

19770: end if;
19771:
19772: if l_first_rec and not l_update then
19773: -- Call Create routine.
19774: hr_utility.set_location(' BEN_VRBL_RT_PRFL_RL_F CREATE_VRBL_RT_PRFL_RULE ',20);
19775: BEN_VRBL_RT_PRFL_RULE_API.CREATE_VRBL_RT_PRFL_RULE(
19776: --
19777: P_VALIDATE => false
19778: ,P_EFFECTIVE_DATE => l_effective_date

Line 19866: hr_utility.set_location(' BEN_VRBL_RT_PRFL_RL_F UPDATE_VRBL_RT_PRFL_RULE ',30);

19862: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
19863: --
19864: IF l_update OR l_dml_operation <> 'UPDATE' THEN
19865: --UPD END
19866: hr_utility.set_location(' BEN_VRBL_RT_PRFL_RL_F UPDATE_VRBL_RT_PRFL_RULE ',30);
19867: BEN_VRBL_RT_PRFL_RULE_API.UPDATE_VRBL_RT_PRFL_RULE(
19868: --
19869: P_VALIDATE => false
19870: ,P_EFFECTIVE_DATE => l_effective_date