APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_CHG_OIPL_ENRT_F

Line 2623: -- and tr.where_clause = l_BEN_LER_CHG_OIPL_ENRT_F

2619: cpe.table_route_id
2620: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
2621: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2622: and cpe.table_route_id = tr.table_route_id
2623: -- and tr.where_clause = l_BEN_LER_CHG_OIPL_ENRT_F
2624: and tr.table_alias = l_table_alias
2625: and cpe.number_of_copies = 1 -- ADDITION
2626: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2627: order by information1, information2; --added for bug: 5151945

Line 2661: from BEN_LER_CHG_OIPL_ENRT_F LOP

2657: c_business_group_id number,
2658: c_new_pk_id number) is
2659: select
2660: LOP.ler_chg_oipl_enrt_id new_value
2661: from BEN_LER_CHG_OIPL_ENRT_F LOP
2662: where
2663: LOP.LER_ID = l_LER_ID and
2664: LOP.OIPL_ID = l_OIPL_ID and
2665: LOP.business_group_id = c_business_group_id

Line 2673: from BEN_LER_CHG_OIPL_ENRT_F LOP1

2669: and effective_end_date ;
2670: --END TEMPIK
2671: /*TEMPIK
2672: and exists ( select null
2673: from BEN_LER_CHG_OIPL_ENRT_F LOP1
2674: where
2675: LOP1.LER_ID = l_LER_ID and
2676: LOP1.OIPL_ID =l_OIPL_ID and
2677: LOP1.business_group_id = c_business_group_id

Line 2680: from BEN_LER_CHG_OIPL_ENRT_F LOP2

2676: LOP1.OIPL_ID =l_OIPL_ID and
2677: LOP1.business_group_id = c_business_group_id
2678: and LOP1.effective_start_date <= c_effective_start_date )
2679: and exists ( select null
2680: from BEN_LER_CHG_OIPL_ENRT_F LOP2
2681: where
2682: LOP2.LER_ID = l_LER_ID and
2683: LOP2.OIPL_ID = l_OIPL_ID and
2684: LOP2.business_group_id = c_business_group_id

Line 2823: (p_base_table_name => 'BEN_LER_CHG_OIPL_ENRT_F',

2819: if c_find_LOP_in_target%found then
2820: --
2821: --TEMPIK
2822: l_dt_rec_found := dt_api.check_min_max_dates
2823: (p_base_table_name => 'BEN_LER_CHG_OIPL_ENRT_F',
2824: p_base_key_column => 'LER_CHG_OIPL_ENRT_ID',
2825: p_base_key_value => l_new_value,
2826: p_from_date => l_min_esd,
2827: p_to_date => l_max_eed );

Line 2883: hr_utility.set_location(' BEN_LER_CHG_OIPL_ENRT_F CREATE_LER_CHG_OIPL_ENRT ',20);

2879: end if;
2880:
2881: if l_first_rec and not l_update then
2882: -- Call Create routine.
2883: hr_utility.set_location(' BEN_LER_CHG_OIPL_ENRT_F CREATE_LER_CHG_OIPL_ENRT ',20);
2884: BEN_LER_CHG_OIPL_ENRT_API.CREATE_LER_CHG_OIPL_ENRT(
2885: --
2886: P_VALIDATE => false
2887: ,P_EFFECTIVE_DATE => l_effective_date

Line 2957: hr_utility.set_location(' BEN_LER_CHG_OIPL_ENRT_F UPDATE_LER_CHG_OIPL_ENRT ',30);

2953: else
2954: --
2955: -- Call Update routine for the pk_id created in prev run .
2956: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2957: hr_utility.set_location(' BEN_LER_CHG_OIPL_ENRT_F UPDATE_LER_CHG_OIPL_ENRT ',30);
2958: --UPD START
2959: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
2960: --
2961: if l_update then