APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIG_DPNT_OTHR_PTIP_F

Line 21101: -- and tr.where_clause = l_BEN_ELIG_DPNT_OTHR_PTIP_F

21097: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
21098: pqh_table_route tr
21099: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
21100: and cpe.table_route_id = tr.table_route_id
21101: -- and tr.where_clause = l_BEN_ELIG_DPNT_OTHR_PTIP_F
21102: and tr.table_alias = l_table_alias
21103: and cpe.number_of_copies = 1 -- ADDITION
21104: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
21105: order by information1, information2; --added for bug: 5151945

Line 21139: from BEN_ELIG_DPNT_OTHR_PTIP_F ETD

21135: c_business_group_id number,
21136: c_new_pk_id number) is
21137: select
21138: ETD.elig_dpnt_othr_ptip_id new_value
21139: from BEN_ELIG_DPNT_OTHR_PTIP_F ETD
21140: where
21141: ETD.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
21142: ETD.PTIP_ID = l_PTIP_ID and
21143: ETD.business_group_id = c_business_group_id

Line 21150: from BEN_ELIG_DPNT_OTHR_PTIP_F ETD1

21146: and effective_end_date ;
21147: --END TEMPIK
21148: /*TEMPIK
21149: and exists ( select null
21150: from BEN_ELIG_DPNT_OTHR_PTIP_F ETD1
21151: where
21152: ETD1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
21153: ETD1.PTIP_ID = l_PTIP_ID and
21154: -- additional filter condition

Line 21159: from BEN_ELIG_DPNT_OTHR_PTIP_F ETD2

21155: ETD1.ORDR_NUM = l_ORDR_NUM and
21156: ETD1.business_group_id = c_business_group_id
21157: and ETD1.effective_start_date <= c_effective_start_date )
21158: and exists ( select null
21159: from BEN_ELIG_DPNT_OTHR_PTIP_F ETD2
21160: where
21161: ETD2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
21162: ETD2.PTIP_ID = l_PTIP_ID and
21163: -- additional filter condition

Line 21326: (p_base_table_name => 'BEN_ELIG_DPNT_OTHR_PTIP_F',

21322: if c_find_ETD_in_target%found then
21323: --
21324: --TEMPIK
21325: l_dt_rec_found := dt_api.check_min_max_dates
21326: (p_base_table_name => 'BEN_ELIG_DPNT_OTHR_PTIP_F',
21327: p_base_key_column => 'ELIG_DPNT_OTHR_PTIP_ID',
21328: p_base_key_value => l_new_value,
21329: p_from_date => l_min_esd,
21330: p_to_date => l_max_eed );

Line 21386: hr_utility.set_location(' BEN_ELIG_DPNT_OTHR_PTIP_F CREATE_ELIG_DPNT_OTHR_PTIP ',20);

21382: end if;
21383:
21384: if l_first_rec and not l_update then
21385: -- Call Create routine.
21386: hr_utility.set_location(' BEN_ELIG_DPNT_OTHR_PTIP_F CREATE_ELIG_DPNT_OTHR_PTIP ',20);
21387: BEN_ELIG_DPNT_OTHR_PTIP_API.CREATE_ELIG_DPNT_OTHR_PTIP(
21388: --
21389: P_VALIDATE => false
21390: ,P_EFFECTIVE_DATE => l_effective_date

Line 21457: hr_utility.set_location(' BEN_ELIG_DPNT_OTHR_PTIP_F UPDATE_ELIG_DPNT_OTHR_PTIP ',30);

21453: else
21454: --
21455: -- Call Update routine for the pk_id created in prev run .
21456: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
21457: hr_utility.set_location(' BEN_ELIG_DPNT_OTHR_PTIP_F UPDATE_ELIG_DPNT_OTHR_PTIP ',30);
21458: --UPD START
21459: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
21460: --
21461: if l_update then