APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_TBCO_USE_RT_F

Line 3587: -- and tr.where_clause = l_BEN_TBCO_USE_RT_F

3583: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
3584: pqh_table_route tr
3585: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3586: and cpe.table_route_id = tr.table_route_id
3587: -- and tr.where_clause = l_BEN_TBCO_USE_RT_F
3588: and tr.table_alias = l_table_alias
3589: and cpe.number_of_copies = 1 -- ADDITION
3590: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
3591: order by information1, information2; --added for bug: 5151945

Line 3625: from BEN_TBCO_USE_RT_F TUR

3621: c_business_group_id number,
3622: c_new_pk_id number) is
3623: select
3624: TUR.tbco_use_rt_id new_value
3625: from BEN_TBCO_USE_RT_F TUR
3626: where
3627: TUR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
3628: TUR.USES_TBCO_FLAG = l_USES_TBCO_FLAG and
3629: TUR.ORDR_NUM = l_ORDR_NUM and

Line 3638: from BEN_TBCO_USE_RT_F TUR1

3634: and effective_end_date ;
3635: --END TEMPIK
3636: /*TEMPIK
3637: and exists ( select null
3638: from BEN_TBCO_USE_RT_F TUR1
3639: where
3640: TUR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
3641: TUR1.USES_TBCO_FLAG = l_USES_TBCO_FLAG and
3642: TUR1.ORDR_NUM = l_ORDR_NUM and

Line 3646: from BEN_TBCO_USE_RT_F TUR2

3642: TUR1.ORDR_NUM = l_ORDR_NUM and
3643: TUR1.business_group_id = c_business_group_id
3644: and TUR1.effective_start_date <= c_effective_start_date )
3645: and exists ( select null
3646: from BEN_TBCO_USE_RT_F TUR2
3647: where
3648: TUR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
3649: TUR2.USES_TBCO_FLAG = l_USES_TBCO_FLAG and
3650: TUR2.ORDR_NUM = l_ORDR_NUM and

Line 3787: (p_base_table_name => 'BEN_TBCO_USE_RT_F',

3783: if c_find_TUR_in_target%found then
3784: --
3785: --TEMPIK
3786: l_dt_rec_found := dt_api.check_min_max_dates
3787: (p_base_table_name => 'BEN_TBCO_USE_RT_F',
3788: p_base_key_column => 'TBCO_USE_RT_ID',
3789: p_base_key_value => l_new_value,
3790: p_from_date => l_min_esd,
3791: p_to_date => l_max_eed );

Line 3845: hr_utility.set_location(' BEN_TBCO_USE_RT_F CREATE_TOBACCO_USE_RATE ',20);

3841: end if;
3842:
3843: if l_first_rec and not l_update then
3844: -- Call Create routine.
3845: hr_utility.set_location(' BEN_TBCO_USE_RT_F CREATE_TOBACCO_USE_RATE ',20);
3846: BEN_TOBACCO_USE_RATE_API.CREATE_TOBACCO_USE_RATE(
3847: --
3848: P_VALIDATE => false
3849: ,P_EFFECTIVE_DATE => l_effective_date

Line 3937: hr_utility.set_location(' BEN_TBCO_USE_RT_F UPDATE_TOBACCO_USE_RATE ',30);

3933: --
3934: IF l_update OR l_dml_operation <> 'UPDATE' THEN
3935: --UPD END
3936: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
3937: hr_utility.set_location(' BEN_TBCO_USE_RT_F UPDATE_TOBACCO_USE_RATE ',30);
3938: BEN_TOBACCO_USE_RATE_API.UPDATE_TOBACCO_USE_RATE(
3939: --
3940: P_VALIDATE => false
3941: ,P_EFFECTIVE_DATE => l_effective_date