APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_RQRS_ENRT_CTFN_F

Line 3578: -- and tr.where_clause = l_BEN_LER_RQRS_ENRT_CTFN_F

3574: cpe.table_route_id
3575: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
3576: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
3577: and cpe.table_route_id = tr.table_route_id
3578: -- and tr.where_clause = l_BEN_LER_RQRS_ENRT_CTFN_F
3579: and tr.table_alias = l_table_alias
3580: and cpe.number_of_copies = 1 --ADDITION
3581: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
3582: order by information1, information2; --added for bug: 5151945

Line 3616: from BEN_LER_RQRS_ENRT_CTFN_F LRE

3612: c_business_group_id number,
3613: c_new_pk_id number) is
3614: select
3615: LRE.ler_rqrs_enrt_ctfn_id new_value
3616: from BEN_LER_RQRS_ENRT_CTFN_F LRE
3617: where
3618: nvl(LRE.LER_ID,-999) = nvl(l_LER_ID,-999) and
3619: nvl(LRE.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
3620: nvl(LRE.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 3629: from BEN_LER_RQRS_ENRT_CTFN_F LRE1

3625: and effective_end_date ;
3626: --END TEMPIK
3627: /*TEMPIK
3628: and exists ( select null
3629: from BEN_LER_RQRS_ENRT_CTFN_F LRE1
3630: where
3631: nvl(LRE1.LER_ID,-999) = nvl(l_LER_ID,-999) and
3632: nvl(LRE1.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
3633: nvl(LRE1.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 3637: from BEN_LER_RQRS_ENRT_CTFN_F LRE2

3633: nvl(LRE1.PL_ID,-999) = nvl(l_PL_ID,-999) and
3634: LRE1.business_group_id = c_business_group_id
3635: and LRE1.effective_start_date <= c_effective_start_date )
3636: and exists ( select null
3637: from BEN_LER_RQRS_ENRT_CTFN_F LRE2
3638: where
3639: nvl(LRE2.LER_ID,-999) = nvl(l_LER_ID,-999) and
3640: nvl(LRE2.OIPL_ID,-999) = nvl(l_OIPL_ID,-999) and
3641: nvl(LRE2.PL_ID,-999) = nvl(l_PL_ID,-999) and

Line 3786: (p_base_table_name => 'BEN_LER_RQRS_ENRT_CTFN_F',

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

Line 3847: hr_utility.set_location(' BEN_LER_RQRS_ENRT_CTFN_F CREATE_LER_RQRS_ENRT_CTFN ',20);

3843:
3844: if l_first_rec and not l_update then
3845: -- Call Create routine.
3846:
3847: hr_utility.set_location(' BEN_LER_RQRS_ENRT_CTFN_F CREATE_LER_RQRS_ENRT_CTFN ',20);
3848: BEN_LER_RQRS_ENRT_CTFN_API.CREATE_LER_RQRS_ENRT_CTFN(
3849: --
3850: P_VALIDATE => false
3851: ,P_EFFECTIVE_DATE => l_effective_date

Line 3920: hr_utility.set_location(' BEN_LER_RQRS_ENRT_CTFN_F UPDATE_LER_RQRS_ENRT_CTFN ',30);

3916: else
3917: --
3918: -- Call Update routine for the pk_id created in prev run .
3919: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
3920: hr_utility.set_location(' BEN_LER_RQRS_ENRT_CTFN_F UPDATE_LER_RQRS_ENRT_CTFN ',30);
3921: --UPD START
3922: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
3923: --
3924: if l_update then