APPS.BEN_PD_COPY_TO_BEN_ONE dependencies on BEN_DPNT_CVG_ELIGY_PRFL_F

Line 11248: -- and tr.where_clause = l_BEN_DPNT_CVG_ELIGY_PRFL_F

11244: from ben_copy_entity_results cpe,
11245: pqh_table_route tr
11246: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11247: and cpe.table_route_id = tr.table_route_id
11248: -- and tr.where_clause = l_BEN_DPNT_CVG_ELIGY_PRFL_F
11249: and tr.table_alias = l_table_alias
11250: and cpe.number_of_copies = 1 --ADDITION
11251: group by cpe.information1,cpe.information2,cpe.information3, cpe.INFORMATION170, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11252: order by information1, information2; --added for bug: 5151945

Line 11286: from BEN_DPNT_CVG_ELIGY_PRFL_F DCE

11282: c_business_group_id number,
11283: c_new_pk_id number) is
11284: select
11285: DCE.dpnt_cvg_eligy_prfl_id new_value
11286: from BEN_DPNT_CVG_ELIGY_PRFL_F DCE
11287: where DCE.name = c_DCE_name
11288: and DCE.business_group_id = c_business_group_id
11289: and DCE.dpnt_cvg_eligy_prfl_id <> c_new_pk_id
11290: --TEMPIK

Line 11296: from BEN_DPNT_CVG_ELIGY_PRFL_F DCE1

11292: and effective_end_date ;
11293: --END TEMPIK
11294: /*TEMPIK
11295: and exists ( select null
11296: from BEN_DPNT_CVG_ELIGY_PRFL_F DCE1
11297: where DCE1.name = c_DCE_name
11298: and DCE1.business_group_id = c_business_group_id
11299: and DCE1.effective_start_date <= c_effective_start_date )
11300: and exists ( select null

Line 11301: from BEN_DPNT_CVG_ELIGY_PRFL_F DCE2

11297: where DCE1.name = c_DCE_name
11298: and DCE1.business_group_id = c_business_group_id
11299: and DCE1.effective_start_date <= c_effective_start_date )
11300: and exists ( select null
11301: from BEN_DPNT_CVG_ELIGY_PRFL_F DCE2
11302: where DCE2.name = c_DCE_name
11303: and DCE2.business_group_id = c_business_group_id
11304: and DCE2.effective_end_date >= c_effective_end_date )
11305: ;

Line 11425: (p_base_table_name => 'BEN_DPNT_CVG_ELIGY_PRFL_F',

11421: if c_find_DCE_in_target%found then
11422: --
11423: --TEMPIK
11424: l_dt_rec_found := dt_api.check_min_max_dates
11425: (p_base_table_name => 'BEN_DPNT_CVG_ELIGY_PRFL_F',
11426: p_base_key_column => 'DPNT_CVG_ELIGY_PRFL_ID',
11427: p_base_key_value => l_new_value,
11428: p_from_date => l_min_esd,
11429: p_to_date => l_max_eed );

Line 11489: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_DPNT_CVG_ELIGY_PRFL_F',l_prefix || r_DCE.INFORMATION170 || l_suffix);

11485: --
11486: l_DPNT_CVG_ELIG_DET_RL := get_fk('FORMULA_ID', r_DCE.INFORMATION257,l_dml_operation);
11487: l_REGN_ID := get_fk('REGN_ID', r_DCE.INFORMATION231,l_dml_operation);
11488: --
11489: ben_pd_copy_to_ben_one.ben_chk_col_len('NAME' ,'BEN_DPNT_CVG_ELIGY_PRFL_F',l_prefix || r_DCE.INFORMATION170 || l_suffix);
11490: --
11491:
11492: l_effective_date := r_DCE.information2;
11493: if ( ben_pd_copy_to_ben_one.g_copy_effective_date is not null and

Line 11500: hr_utility.set_location(' BEN_DPNT_CVG_ELIGY_PRFL_F CREATE_DPNT_CVG_ELIG_PRFL ',20);

11496: end if;
11497:
11498: if l_first_rec and not l_update then
11499: -- Call Create routine.
11500: hr_utility.set_location(' BEN_DPNT_CVG_ELIGY_PRFL_F CREATE_DPNT_CVG_ELIG_PRFL ',20);
11501: BEN_DPNT_CVG_ELIG_PRFL_API.CREATE_DPNT_CVG_ELIG_PRFL(
11502: --
11503: P_VALIDATE => false
11504: ,P_EFFECTIVE_DATE => l_effective_date

Line 11605: hr_utility.set_location(' BEN_DPNT_CVG_ELIGY_PRFL_F UPDATE_DPNT_CVG_ELIG_PRFL ',30);

11601: IF l_update OR l_dml_operation <> 'UPDATE' THEN
11602: --UPD END
11603: -- Call Update routine for the pk_id created in prev run .
11604: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
11605: hr_utility.set_location(' BEN_DPNT_CVG_ELIGY_PRFL_F UPDATE_DPNT_CVG_ELIG_PRFL ',30);
11606: BEN_DPNT_CVG_ELIG_PRFL_API.UPDATE_DPNT_CVG_ELIG_PRFL(
11607: --
11608: P_VALIDATE => false
11609: ,P_EFFECTIVE_DATE => l_effective_date