APPS.BEN_PD_COPY_TO_BEN_TWO dependencies on BEN_WV_PRTN_RSN_PL_F

Line 5487: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_PL_F

5483: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5484: pqh_table_route tr
5485: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5486: and cpe.table_route_id = tr.table_route_id
5487: -- and tr.where_clause = l_BEN_WV_PRTN_RSN_PL_F
5488: and tr.table_alias = l_table_alias
5489: and cpe.number_of_copies = 1 -- ADDITION
5490: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5491: order by information1, information2; --added for bug: 5151945

Line 5525: from BEN_WV_PRTN_RSN_PL_F WPN

5521: c_business_group_id number,
5522: c_new_pk_id number) is
5523: select
5524: WPN.wv_prtn_rsn_pl_id new_value
5525: from BEN_WV_PRTN_RSN_PL_F WPN
5526: where
5527: WPN.PL_ID = l_PL_ID and
5528: WPN.WV_PRTN_RSN_CD = l_WV_PRTN_RSN_CD and
5529: WPN.business_group_id = c_business_group_id

Line 5537: from BEN_WV_PRTN_RSN_PL_F WPN1

5533: and effective_end_date ;
5534: --END TEMPIK
5535: /*TEMPIK
5536: and exists ( select null
5537: from BEN_WV_PRTN_RSN_PL_F WPN1
5538: where
5539: WPN1.PL_ID = l_PL_ID and
5540: WPN1.WV_PRTN_RSN_CD = l_WV_PRTN_RSN_CD and
5541: WPN1.business_group_id = c_business_group_id

Line 5544: from BEN_WV_PRTN_RSN_PL_F WPN2

5540: WPN1.WV_PRTN_RSN_CD = l_WV_PRTN_RSN_CD and
5541: WPN1.business_group_id = c_business_group_id
5542: and WPN1.effective_start_date <= c_effective_start_date )
5543: and exists ( select null
5544: from BEN_WV_PRTN_RSN_PL_F WPN2
5545: where
5546: WPN2.PL_ID = l_PL_ID and
5547: WPN2.WV_PRTN_RSN_CD = l_WV_PRTN_RSN_CD and
5548: WPN2.business_group_id = c_business_group_id

Line 5691: (p_base_table_name => 'BEN_WV_PRTN_RSN_PL_F',

5687: if c_find_WPN_in_target%found then
5688: --
5689: --TEMPIK
5690: l_dt_rec_found := dt_api.check_min_max_dates
5691: (p_base_table_name => 'BEN_WV_PRTN_RSN_PL_F',
5692: p_base_key_column => 'WV_PRTN_RSN_PL_ID',
5693: p_base_key_value => l_new_value,
5694: p_from_date => l_min_esd,
5695: p_to_date => l_max_eed );

Line 5750: hr_utility.set_location(' BEN_WV_PRTN_RSN_PL_F CREATE_WV_PRTN_REASON_PL ',20);

5746: end if;
5747:
5748: if l_first_rec and not l_update then
5749: -- Call Create routine.
5750: hr_utility.set_location(' BEN_WV_PRTN_RSN_PL_F CREATE_WV_PRTN_REASON_PL ',20);
5751: BEN_WV_PRTN_REASON_PL_API.CREATE_WV_PRTN_REASON_PL(
5752: --
5753: P_VALIDATE => false
5754: ,P_EFFECTIVE_DATE => l_effective_date

Line 5816: hr_utility.set_location(' BEN_WV_PRTN_RSN_PL_F UPDATE_WV_PRTN_REASON_PL ',30);

5812: else
5813: --
5814: -- Call Update routine for the pk_id created in prev run .
5815: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
5816: hr_utility.set_location(' BEN_WV_PRTN_RSN_PL_F UPDATE_WV_PRTN_REASON_PL ',30);
5817: --UPD START
5818: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
5819: --
5820: if l_update then