APPS.BEN_PD_COPY_TO_BEN_FIVE dependencies on BEN_ELIG_MLTRY_STAT_CVG_F

Line 11785: l_MLTRY_STAT_CD ben_elig_mltry_stat_cvg_f.mltry_stat_cd%type;

11781: --
11782: l_CVG_STRT_RL number;
11783: l_CVG_THRU_RL number;
11784: l_DPNT_CVG_ELIGY_PRFL_ID number;
11785: l_MLTRY_STAT_CD ben_elig_mltry_stat_cvg_f.mltry_stat_cd%type;
11786: cursor c_unique_EMC(l_table_alias varchar2) is
11787: select distinct cpe.information1,
11788: cpe.information2,
11789: cpe.information3,

Line 11796: -- and tr.where_clause = l_BEN_ELIG_MLTRY_STAT_CVG_F

11792: from ben_copy_entity_results cpe,
11793: pqh_table_route tr
11794: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
11795: and cpe.table_route_id = tr.table_route_id
11796: -- and tr.where_clause = l_BEN_ELIG_MLTRY_STAT_CVG_F
11797: and tr.table_alias = l_table_alias
11798: and cpe.number_of_copies = 1 -- ADDITION
11799: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
11800: order by information1, information2; --added for bug: 5151945

Line 11834: from BEN_ELIG_MLTRY_STAT_CVG_F EMC

11830: c_business_group_id number,
11831: c_new_pk_id number) is
11832: select
11833: EMC.elig_mltry_stat_cvg_id new_value
11834: from BEN_ELIG_MLTRY_STAT_CVG_F EMC
11835: where
11836: nvl(EMC.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
11837: EMC.MLTRY_STAT_CD = l_MLTRY_STAT_CD and
11838: EMC.business_group_id = c_business_group_id

Line 11846: from BEN_ELIG_MLTRY_STAT_CVG_F EMC1

11842: and effective_end_date ;
11843: --END TEMPIK
11844: /*TEMPIK
11845: and exists ( select null
11846: from BEN_ELIG_MLTRY_STAT_CVG_F EMC1
11847: where
11848: nvl(EMC1.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
11849: EMC1.MLTRY_STAT_CD = l_MLTRY_STAT_CD and
11850: EMC1.business_group_id = c_business_group_id

Line 11853: from BEN_ELIG_MLTRY_STAT_CVG_F EMC2

11849: EMC1.MLTRY_STAT_CD = l_MLTRY_STAT_CD and
11850: EMC1.business_group_id = c_business_group_id
11851: and EMC1.effective_start_date <= c_effective_start_date )
11852: and exists ( select null
11853: from BEN_ELIG_MLTRY_STAT_CVG_F EMC2
11854: where
11855: nvl(EMC2.DPNT_CVG_ELIGY_PRFL_ID,-999) = nvl(l_DPNT_CVG_ELIGY_PRFL_ID,-999) and
11856: EMC2.MLTRY_STAT_CD = l_MLTRY_STAT_CD and
11857: EMC2.business_group_id = c_business_group_id

Line 12002: (p_base_table_name => 'BEN_ELIG_MLTRY_STAT_CVG_F',

11998: fetch c_find_EMC_in_target into l_new_value ;
11999: if c_find_EMC_in_target%found then
12000: --TEMPIK
12001: l_dt_rec_found := dt_api.check_min_max_dates
12002: (p_base_table_name => 'BEN_ELIG_MLTRY_STAT_CVG_F',
12003: p_base_key_column => 'ELIG_MLTRY_STAT_CVG_ID',
12004: p_base_key_value => l_new_value,
12005: p_from_date => l_min_esd,
12006: p_to_date => l_max_eed );

Line 12064: hr_utility.set_location(' BEN_ELIG_MLTRY_STAT_CVG_F CREATE_ELIG_MLTRY_STAT_CVG ',20);

12060:
12061: --if l_first_rec then
12062: if l_first_rec and not l_update then
12063: -- Call Create routine.
12064: hr_utility.set_location(' BEN_ELIG_MLTRY_STAT_CVG_F CREATE_ELIG_MLTRY_STAT_CVG ',20);
12065: BEN_ELIG_MLTRY_STAT_CVG_API.CREATE_ELIG_MLTRY_STAT_CVG(
12066: --
12067: P_VALIDATE => false
12068: ,P_EFFECTIVE_DATE => l_effective_date

Line 12133: hr_utility.set_location(' BEN_ELIG_MLTRY_STAT_CVG_F UPDATE_ELIG_MLTRY_STAT_CVG ',30);

12129: else
12130: --
12131: -- Call Update routine for the pk_id created in prev run .
12132: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
12133: hr_utility.set_location(' BEN_ELIG_MLTRY_STAT_CVG_F UPDATE_ELIG_MLTRY_STAT_CVG ',30);
12134: --UPD START
12135: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
12136: --
12137: if l_update then