APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_WV_PRTN_RSN_CTFN_PL_F

Line 5009: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_CTFN_PL_F

5005: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5006: pqh_table_route tr
5007: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5008: and cpe.table_route_id = tr.table_route_id
5009: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_CTFN_PL_F
5010: and tr.table_alias = l_table_alias
5011: and cpe.number_of_copies = 1 -- ADDITION
5012: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5013: order by information1, information2; --added for bug: 5151945

Line 5047: from BEN_WV_PRTN_RSN_CTFN_PL_F WCN

5043: c_business_group_id number,
5044: c_new_pk_id number) is
5045: select
5046: WCN.wv_prtn_rsn_ctfn_pl_id new_value
5047: from BEN_WV_PRTN_RSN_CTFN_PL_F WCN
5048: where
5049: WCN.WV_PRTN_RSN_PL_ID = l_WV_PRTN_RSN_PL_ID and
5050: WCN.WV_PRTN_CTFN_TYP_CD = l_WV_PRTN_CTFN_TYP_CD and
5051: WCN.business_group_id = c_business_group_id

Line 5059: from BEN_WV_PRTN_RSN_CTFN_PL_F WCN1

5055: and effective_end_date ;
5056: --END TEMPIK
5057: /*TEMPIK
5058: and exists ( select null
5059: from BEN_WV_PRTN_RSN_CTFN_PL_F WCN1
5060: where
5061: WCN1.WV_PRTN_RSN_PL_ID = l_WV_PRTN_RSN_PL_ID and
5062: WCN1.WV_PRTN_CTFN_TYP_CD = l_WV_PRTN_CTFN_TYP_CD and
5063: WCN1.business_group_id = c_business_group_id

Line 5066: from BEN_WV_PRTN_RSN_CTFN_PL_F WCN2

5062: WCN1.WV_PRTN_CTFN_TYP_CD = l_WV_PRTN_CTFN_TYP_CD and
5063: WCN1.business_group_id = c_business_group_id
5064: and WCN1.effective_start_date <= c_effective_start_date )
5065: and exists ( select null
5066: from BEN_WV_PRTN_RSN_CTFN_PL_F WCN2
5067: where
5068: WCN2.WV_PRTN_RSN_PL_ID = l_WV_PRTN_RSN_PL_ID and
5069: WCN2.WV_PRTN_CTFN_TYP_CD = l_WV_PRTN_CTFN_TYP_CD and
5070: WCN2.business_group_id = c_business_group_id

Line 5215: (p_base_table_name => 'BEN_WV_PRTN_RSN_CTFN_PL_F',

5211: if c_find_WCN_in_target%found then
5212: --
5213: --TEMPIK
5214: l_dt_rec_found := dt_api.check_min_max_dates
5215: (p_base_table_name => 'BEN_WV_PRTN_RSN_CTFN_PL_F',
5216: p_base_key_column => 'WV_PRTN_RSN_CTFN_PL_ID',
5217: p_base_key_value => l_new_value,
5218: p_from_date => l_min_esd,
5219: p_to_date => l_max_eed );

Line 5274: hr_utility.set_location(' BEN_WV_PRTN_RSN_CTFN_PL_F CREATE_WV_PRTN_RSN_CTFN_PL ',20);

5270: end if;
5271:
5272: if l_first_rec and not l_update then
5273: -- Call Create routine.
5274: hr_utility.set_location(' BEN_WV_PRTN_RSN_CTFN_PL_F CREATE_WV_PRTN_RSN_CTFN_PL ',20);
5275: BEN_WV_PRTN_RSN_CTFN_PL_API.CREATE_WV_PRTN_RSN_CTFN_PL(
5276: --
5277: P_VALIDATE => false
5278: ,P_EFFECTIVE_DATE => l_effective_date

Line 5343: hr_utility.set_location(' BEN_WV_PRTN_RSN_CTFN_PL_F UPDATE_WV_PRTN_RSN_CTFN_PL ',30);

5339: else
5340: --
5341: -- Call Update routine for the pk_id created in prev run .
5342: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5343: hr_utility.set_location(' BEN_WV_PRTN_RSN_CTFN_PL_F UPDATE_WV_PRTN_RSN_CTFN_PL ',30);
5344: --UPD START
5345: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
5346: --
5347: if l_update then