APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_ELIG_DSBLD_STAT_CVG_F

Line 11308: l_DSBLD_CD ben_elig_dsbld_stat_cvg_f.dsbld_cd%type;

11304: --
11305: l_CVG_STRT_RL number;
11306: l_CVG_THRU_RL number;
11307: l_DPNT_CVG_ELIGY_PRFL_ID number;
11308: l_DSBLD_CD ben_elig_dsbld_stat_cvg_f.dsbld_cd%type;
11309: cursor c_unique_EDC(l_table_alias varchar2) is
11310: select distinct cpe.information1,
11311: cpe.information2,
11312: cpe.information3,

Line 11320: -- and tr.where_clause = l_BEN_ELIG_DSBLD_STAT_CVG_F

11316: from ben_copy_entity_results cpe,
11317: pqh_table_route tr
11318: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11319: and cpe.table_route_id = tr.table_route_id
11320: -- and tr.where_clause = l_BEN_ELIG_DSBLD_STAT_CVG_F
11321: and tr.table_alias = l_table_alias
11322: and cpe.number_of_copies = 1 -- ADDITION
11323: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11324: order by information1, information2; --added for bug: 5151945

Line 11358: from BEN_ELIG_DSBLD_STAT_CVG_F EDC

11354: c_business_group_id number,
11355: c_new_pk_id number) is
11356: select
11357: EDC.elig_dsbld_stat_cvg_id new_value
11358: from BEN_ELIG_DSBLD_STAT_CVG_F EDC
11359: where
11360: nvl(EDC.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
11361: EDC.DSBLD_CD = l_DSBLD_CD and
11362: EDC.business_group_id = c_business_group_id

Line 11370: from BEN_ELIG_DSBLD_STAT_CVG_F EDC1

11366: and effective_end_date ;
11367: --END TEMPIK
11368: /*TEMPIK
11369: and exists ( select null
11370: from BEN_ELIG_DSBLD_STAT_CVG_F EDC1
11371: where
11372: nvl(EDC1.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
11373: EDC1.DSBLD_CD = l_DSBLD_CD and
11374: EDC1.business_group_id = c_business_group_id

Line 11377: from BEN_ELIG_DSBLD_STAT_CVG_F EDC2

11373: EDC1.DSBLD_CD = l_DSBLD_CD and
11374: EDC1.business_group_id = c_business_group_id
11375: and EDC1.effective_start_date <= c_effective_start_date )
11376: and exists ( select null
11377: from BEN_ELIG_DSBLD_STAT_CVG_F EDC2
11378: where
11379: nvl(EDC2.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
11380: EDC2.DSBLD_CD = l_DSBLD_CD and
11381: EDC2.business_group_id = c_business_group_id

Line 11519: (p_base_table_name => 'BEN_ELIG_DSBLD_STAT_CVG_F',

11515: if c_find_EDC_in_target%found then
11516: --
11517: --TEMPIK
11518: l_dt_rec_found := dt_api.check_min_max_dates
11519: (p_base_table_name => 'BEN_ELIG_DSBLD_STAT_CVG_F',
11520: p_base_key_column => 'ELIG_DSBLD_STAT_CVG_ID',
11521: p_base_key_value => l_new_value,
11522: p_from_date => l_min_esd,
11523: p_to_date => l_max_eed );

Line 11581: hr_utility.set_location(' BEN_ELIG_DSBLD_STAT_CVG_F CREATE_ELIG_DSBLD_STAT_CVG ',20);

11577:
11578: --if l_first_rec then
11579: if l_first_rec and not l_update then
11580: -- Call Create routine.
11581: hr_utility.set_location(' BEN_ELIG_DSBLD_STAT_CVG_F CREATE_ELIG_DSBLD_STAT_CVG ',20);
11582: BEN_ELIG_DSBLD_STAT_CVG_API.CREATE_ELIG_DSBLD_STAT_CVG(
11583: --
11584: P_VALIDATE => false
11585: ,P_EFFECTIVE_DATE => l_effective_date

Line 11650: hr_utility.set_location(' BEN_ELIG_DSBLD_STAT_CVG_F UPDATE_ELIG_DSBLD_STAT_CVG ',30);

11646: else
11647: --
11648: -- Call Update routine for the pk_id created in prev run .
11649: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
11650: hr_utility.set_location(' BEN_ELIG_DSBLD_STAT_CVG_F UPDATE_ELIG_DSBLD_STAT_CVG ',30);
11651: --UPD START
11652: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
11653: --
11654: if l_update then