APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 5868: -- and tr.where_clause = l_BEN_ELIG_DPNT_CVRD_OTHR_PL_F

5864: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
5865: pqh_table_route tr
5866: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
5867: and cpe.table_route_id = tr.table_route_id
5868: -- and tr.where_clause = l_BEN_ELIG_DPNT_CVRD_OTHR_PL_F
5869: and tr.table_alias = l_table_alias
5870: and cpe.number_of_copies = 1 -- ADDITION
5871: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
5872: order by information1, information2; --added for bug: 5151945

Line 5906: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP

5902: c_business_group_id number,
5903: c_new_pk_id number) is
5904: select
5905: EDP.elig_dpnt_cvrd_othr_pl_id new_value
5906: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP
5907: where
5908: EDP.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
5909: EDP.PL_ID = l_PL_ID and
5910: EDP.ORDR_NUM = l_ORDR_NUM and

Line 5918: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP1

5914: and effective_end_date ;
5915: --END TEMPIK
5916: /*TEMPIK
5917: and exists ( select null
5918: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP1
5919: where
5920: EDP1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
5921: EDP1.PL_ID = l_PL_ID and
5922: EDP1.ORDR_NUM = l_ORDR_NUM and

Line 5926: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP2

5922: EDP1.ORDR_NUM = l_ORDR_NUM and
5923: EDP1.business_group_id = c_business_group_id
5924: and EDP1.effective_start_date <= c_effective_start_date )
5925: and exists ( select null
5926: from BEN_ELIG_DPNT_CVRD_OTHR_PL_F EDP2
5927: where
5928: EDP2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
5929: EDP2.PL_ID = l_PL_ID and
5930: EDP2.ORDR_NUM = l_ORDR_NUM and

Line 6089: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_OTHR_PL_F',

6085: if c_find_EDP_in_target%found then
6086: --
6087: --TEMPIK
6088: l_dt_rec_found := dt_api.check_min_max_dates
6089: (p_base_table_name => 'BEN_ELIG_DPNT_CVRD_OTHR_PL_F',
6090: p_base_key_column => 'ELIG_DPNT_CVRD_OTHR_PL_ID',
6091: p_base_key_value => l_new_value,
6092: p_from_date => l_min_esd,
6093: p_to_date => l_max_eed );

Line 6149: hr_utility.set_location(' BEN_ELIG_DPNT_CVRD_OTHR_PL_F CREATE_ELIG_DPNT_CVD_OTHR_PL ',20);

6145: end if;
6146:
6147: if l_first_rec and not l_update then
6148: -- Call Create routine.
6149: hr_utility.set_location(' BEN_ELIG_DPNT_CVRD_OTHR_PL_F CREATE_ELIG_DPNT_CVD_OTHR_PL ',20);
6150: BEN_ELIG_DPNT_CVD_OTHR_PL_API.CREATE_ELIG_DPNT_CVD_OTHR_PL(
6151: --
6152: P_VALIDATE => false
6153: ,P_EFFECTIVE_DATE => l_effective_date

Line 6221: hr_utility.set_location(' BEN_ELIG_DPNT_CVRD_OTHR_PL_F UPDATE_ELIG_DPNT_CVD_OTHR_PL ',30);

6217: else
6218: --
6219: -- Call Update routine for the pk_id created in prev run .
6220: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
6221: hr_utility.set_location(' BEN_ELIG_DPNT_CVRD_OTHR_PL_F UPDATE_ELIG_DPNT_CVD_OTHR_PL ',30);
6222: --UPD START
6223: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
6224: --
6225: if l_update then