APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_LER_CHG_PL_NIP_ENRT_F

Line 2135: -- and tr.where_clause = l_BEN_LER_CHG_PL_NIP_ENRT_F

2131: cpe.table_route_id
2132: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe, pqh_table_route tr
2133: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
2134: and cpe.table_route_id = tr.table_route_id
2135: -- and tr.where_clause = l_BEN_LER_CHG_PL_NIP_ENRT_F
2136: and tr.table_alias = l_table_alias
2137: and cpe.number_of_copies = 1 --ADDITION
2138: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
2139: order by information1, information2; --added for bug: 5151945

Line 2173: from BEN_LER_CHG_PL_NIP_ENRT_F LPE

2169: c_business_group_id number,
2170: c_new_pk_id number) is
2171: select
2172: LPE.ler_chg_pl_nip_enrt_id new_value
2173: from BEN_LER_CHG_PL_NIP_ENRT_F LPE
2174: where
2175: nvl(LPE.LER_ID,-999) = nvl(l_LER_ID,-999) and
2176: nvl(LPE.PL_ID,-999) = nvl(l_PL_ID,-999) and
2177: LPE.business_group_id = c_business_group_id

Line 2185: from BEN_LER_CHG_PL_NIP_ENRT_F LPE1

2181: and effective_end_date ;
2182: --END TEMPIK
2183: /*TEMPIK
2184: and exists ( select null
2185: from BEN_LER_CHG_PL_NIP_ENRT_F LPE1
2186: where
2187: nvl(LPE1.LER_ID,-999) = nvl(l_LER_ID,-999) and
2188: nvl(LPE1.PL_ID,-999) = nvl(l_PL_ID,-999) and
2189: LPE1.business_group_id = c_business_group_id

Line 2192: from BEN_LER_CHG_PL_NIP_ENRT_F LPE2

2188: nvl(LPE1.PL_ID,-999) = nvl(l_PL_ID,-999) and
2189: LPE1.business_group_id = c_business_group_id
2190: and LPE1.effective_start_date <= c_effective_start_date )
2191: and exists ( select null
2192: from BEN_LER_CHG_PL_NIP_ENRT_F LPE2
2193: where
2194: nvl(LPE2.LER_ID,-999) = nvl(l_LER_ID,-999) and
2195: nvl(LPE2.PL_ID,-999) = nvl(l_PL_ID,-999) and
2196: LPE2.business_group_id = c_business_group_id

Line 2338: (p_base_table_name => 'BEN_LER_CHG_PL_NIP_ENRT_F',

2334: if c_find_LPE_in_target%found then
2335: --
2336: --TEMPIK
2337: l_dt_rec_found := dt_api.check_min_max_dates
2338: (p_base_table_name => 'BEN_LER_CHG_PL_NIP_ENRT_F',
2339: p_base_key_column => 'LER_CHG_PL_NIP_ENRT_ID',
2340: p_base_key_value => l_new_value,
2341: p_from_date => l_min_esd,
2342: p_to_date => l_max_eed );

Line 2397: hr_utility.set_location(' BEN_LER_CHG_PL_NIP_ENRT_F CREATE_LER_CHG_PL_NIP_ENRT ',20);

2393: end if;
2394:
2395: if l_first_rec and not l_update then
2396: -- Call Create routine.
2397: hr_utility.set_location(' BEN_LER_CHG_PL_NIP_ENRT_F CREATE_LER_CHG_PL_NIP_ENRT ',20);
2398: BEN_LER_CHG_PL_NIP_ENRT_API.CREATE_LER_CHG_PL_NIP_ENRT(
2399: --
2400: P_VALIDATE => false
2401: ,P_EFFECTIVE_DATE => l_effective_date

Line 2472: hr_utility.set_location(' BEN_LER_CHG_PL_NIP_ENRT_F UPDATE_LER_CHG_PL_NIP_ENRT ',30);

2468: else
2469: --
2470: -- Call Update routine for the pk_id created in prev run .
2471: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
2472: hr_utility.set_location(' BEN_LER_CHG_PL_NIP_ENRT_F UPDATE_LER_CHG_PL_NIP_ENRT ',30);
2473: --UPD START
2474: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
2475: --
2476: if l_update then