APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_ENRLD_ANTHR_PLIP_RT_F

Line 15297: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PLIP_RT_F

15293: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
15294: pqh_table_route tr
15295: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
15296: and cpe.table_route_id = tr.table_route_id
15297: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PLIP_RT_F
15298: and tr.table_alias = l_table_alias
15299: and cpe.number_of_copies = 1 -- ADDITION
15300: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
15301: order by information1, information2; --added for bug: 5151945

Line 15335: from BEN_ENRLD_ANTHR_PLIP_RT_F EAR

15331: c_business_group_id number,
15332: c_new_pk_id number) is
15333: select
15334: EAR.enrld_anthr_plip_rt_id new_value
15335: from BEN_ENRLD_ANTHR_PLIP_RT_F EAR
15336: where
15337: EAR.PLIP_ID = l_PLIP_ID and
15338: EAR.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15339: EAR.business_group_id = c_business_group_id

Line 15347: from BEN_ENRLD_ANTHR_PLIP_RT_F EAR1

15343: and effective_end_date ;
15344: --END TEMPIK
15345: /*TEMPIK
15346: and exists ( select null
15347: from BEN_ENRLD_ANTHR_PLIP_RT_F EAR1
15348: where
15349: EAR1.PLIP_ID = l_PLIP_ID and
15350: EAR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15351: EAR1.business_group_id = c_business_group_id

Line 15354: from BEN_ENRLD_ANTHR_PLIP_RT_F EAR2

15350: EAR1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15351: EAR1.business_group_id = c_business_group_id
15352: and EAR1.effective_start_date <= c_effective_start_date )
15353: and exists ( select null
15354: from BEN_ENRLD_ANTHR_PLIP_RT_F EAR2
15355: where
15356: EAR2.PLIP_ID = l_PLIP_ID and
15357: EAR2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
15358: EAR2.business_group_id = c_business_group_id

Line 15493: (p_base_table_name => 'BEN_ENRLD_ANTHR_PLIP_RT_F',

15489: if c_find_EAR_in_target%found then
15490: --
15491: --TEMPIK
15492: l_dt_rec_found := dt_api.check_min_max_dates
15493: (p_base_table_name => 'BEN_ENRLD_ANTHR_PLIP_RT_F',
15494: p_base_key_column => 'ENRLD_ANTHR_PLIP_RT_ID',
15495: p_base_key_value => l_new_value,
15496: p_from_date => l_min_esd,
15497: p_to_date => l_max_eed );

Line 15551: hr_utility.set_location(' BEN_ENRLD_ANTHR_PLIP_RT_F CREATE_ENRLD_ANTHR_PLIP_RT ',20);

15547: end if;
15548:
15549: if l_first_rec and not l_update then
15550: -- Call Create routine.
15551: hr_utility.set_location(' BEN_ENRLD_ANTHR_PLIP_RT_F CREATE_ENRLD_ANTHR_PLIP_RT ',20);
15552: BEN_ENRLD_ANTHR_PLIP_RT_API.CREATE_ENRLD_ANTHR_PLIP_RT(
15553: --
15554: P_VALIDATE => false
15555: ,P_EFFECTIVE_DATE => l_effective_date

Line 15644: hr_utility.set_location(' BEN_ENRLD_ANTHR_PLIP_RT_F UPDATE_ENRLD_ANTHR_PLIP_RT ',30);

15640: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15641: --
15642: IF l_update OR l_dml_operation <> 'UPDATE' THEN
15643: --UPD END
15644: hr_utility.set_location(' BEN_ENRLD_ANTHR_PLIP_RT_F UPDATE_ENRLD_ANTHR_PLIP_RT ',30);
15645: BEN_ENRLD_ANTHR_PLIP_RT_API.UPDATE_ENRLD_ANTHR_PLIP_RT(
15646: --
15647: P_VALIDATE => false
15648: ,P_EFFECTIVE_DATE => l_effective_date