APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_CHG_PLIP_ENRT_F

Line 7904: -- and tr.where_clause = l_BEN_LER_CHG_PLIP_ENRT_F

7900: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
7901: pqh_table_route tr
7902: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
7903: and cpe.table_route_id = tr.table_route_id
7904: -- and tr.where_clause = l_BEN_LER_CHG_PLIP_ENRT_F
7905: and tr.table_alias = l_table_alias
7906: and cpe.number_of_copies = 1 -- ADDITION
7907: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
7908: order by information1, information2; --added for bug: 5151945

Line 7942: from BEN_LER_CHG_PLIP_ENRT_F LPR1

7938: c_business_group_id number,
7939: c_new_pk_id number) is
7940: select
7941: LPR1.ler_chg_plip_enrt_id new_value
7942: from BEN_LER_CHG_PLIP_ENRT_F LPR1
7943: where
7944: LPR1.LER_ID = l_LER_ID and
7945: LPR1.PLIP_ID = l_PLIP_ID and
7946: LPR1.business_group_id = c_business_group_id

Line 7954: from BEN_LER_CHG_PLIP_ENRT_F LPR11

7950: and effective_end_date ;
7951: --END TEMPIK
7952: /*TEMPIK
7953: and exists ( select null
7954: from BEN_LER_CHG_PLIP_ENRT_F LPR11
7955: where
7956: LPR11.LER_ID = l_LER_ID and
7957: LPR11.PLIP_ID = l_PLIP_ID and
7958: LPR11.business_group_id = c_business_group_id

Line 7961: from BEN_LER_CHG_PLIP_ENRT_F LPR12

7957: LPR11.PLIP_ID = l_PLIP_ID and
7958: LPR11.business_group_id = c_business_group_id
7959: and LPR11.effective_start_date <= c_effective_start_date )
7960: and exists ( select null
7961: from BEN_LER_CHG_PLIP_ENRT_F LPR12
7962: where
7963: LPR12.LER_ID = l_LER_ID and
7964: LPR12.PLIP_ID = l_PLIP_ID and
7965: LPR12.business_group_id = c_business_group_id

Line 8110: (p_base_table_name => 'BEN_LER_CHG_PLIP_ENRT_F',

8106: if c_find_LPR1_in_target%found then
8107: --
8108: --TEMPIK
8109: l_dt_rec_found := dt_api.check_min_max_dates
8110: (p_base_table_name => 'BEN_LER_CHG_PLIP_ENRT_F',
8111: p_base_key_column => 'LER_CHG_PLIP_ENRT_ID',
8112: p_base_key_value => l_new_value,
8113: p_from_date => l_min_esd,
8114: p_to_date => l_max_eed );

Line 8170: hr_utility.set_location(' BEN_LER_CHG_PLIP_ENRT_F CREATE_LER_CHG_PLAN_ENRT ',20);

8166: end if;
8167:
8168: if l_first_rec and not l_update then
8169: -- Call Create routine.
8170: hr_utility.set_location(' BEN_LER_CHG_PLIP_ENRT_F CREATE_LER_CHG_PLAN_ENRT ',20);
8171: BEN_LER_CHG_PLAN_ENRT_API.CREATE_LER_CHG_PLAN_ENRT(
8172: --
8173: P_VALIDATE => false
8174: ,P_EFFECTIVE_DATE => l_effective_date

Line 8245: hr_utility.set_location(' BEN_LER_CHG_PLIP_ENRT_F UPDATE_LER_CHG_PLAN_ENRT ',30);

8241: else
8242: --
8243: -- Call Update routine for the pk_id created in prev run .
8244: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
8245: hr_utility.set_location(' BEN_LER_CHG_PLIP_ENRT_F UPDATE_LER_CHG_PLAN_ENRT ',30);
8246: --UPD START
8247: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
8248: --
8249: if l_update then