APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_ENRLD_ANTHR_PTIP_RT_F

Line 14373: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PTIP_RT_F

14369: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14370: pqh_table_route tr
14371: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14372: and cpe.table_route_id = tr.table_route_id
14373: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PTIP_RT_F
14374: and tr.table_alias = l_table_alias
14375: and cpe.number_of_copies = 1 -- ADDITION
14376: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14377: order by information1, information2; --added for bug: 5151945

Line 14411: from BEN_ENRLD_ANTHR_PTIP_RT_F ENT

14407: c_business_group_id number,
14408: c_new_pk_id number) is
14409: select
14410: ENT.enrld_anthr_ptip_rt_id new_value
14411: from BEN_ENRLD_ANTHR_PTIP_RT_F ENT
14412: where
14413: ENT.PTIP_ID = l_PTIP_ID and
14414: ENT.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14415: ENT.business_group_id = c_business_group_id

Line 14423: from BEN_ENRLD_ANTHR_PTIP_RT_F ENT1

14419: and effective_end_date ;
14420: --END TEMPIK
14421: /*TEMPIK
14422: and exists ( select null
14423: from BEN_ENRLD_ANTHR_PTIP_RT_F ENT1
14424: where
14425: ENT1.PTIP_ID = l_PTIP_ID and
14426: ENT1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14427: ENT1.business_group_id = c_business_group_id

Line 14430: from BEN_ENRLD_ANTHR_PTIP_RT_F ENT2

14426: ENT1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14427: ENT1.business_group_id = c_business_group_id
14428: and ENT1.effective_start_date <= c_effective_start_date )
14429: and exists ( select null
14430: from BEN_ENRLD_ANTHR_PTIP_RT_F ENT2
14431: where
14432: ENT2.PTIP_ID = l_PTIP_ID and
14433: ENT2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14434: ENT2.business_group_id = c_business_group_id

Line 14569: (p_base_table_name => 'BEN_ENRLD_ANTHR_PTIP_RT_F',

14565: if c_find_ENT_in_target%found then
14566: --
14567: --TEMPIK
14568: l_dt_rec_found := dt_api.check_min_max_dates
14569: (p_base_table_name => 'BEN_ENRLD_ANTHR_PTIP_RT_F',
14570: p_base_key_column => 'ENRLD_ANTHR_PTIP_RT_ID',
14571: p_base_key_value => l_new_value,
14572: p_from_date => l_min_esd,
14573: p_to_date => l_max_eed );

Line 14627: hr_utility.set_location(' BEN_ENRLD_ANTHR_PTIP_RT_F CREATE_ENRLD_ANTHR_PTIP_RT ',20);

14623: end if;
14624:
14625: if l_first_rec and not l_update then
14626: -- Call Create routine.
14627: hr_utility.set_location(' BEN_ENRLD_ANTHR_PTIP_RT_F CREATE_ENRLD_ANTHR_PTIP_RT ',20);
14628: BEN_ENRLD_ANTHR_PTIP_RT_API.CREATE_ENRLD_ANTHR_PTIP_RT(
14629: --
14630: P_VALIDATE => false
14631: ,P_EFFECTIVE_DATE => l_effective_date

Line 14721: hr_utility.set_location(' BEN_ENRLD_ANTHR_PTIP_RT_F UPDATE_ENRLD_ANTHR_PTIP_RT ',30);

14717: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
14718: --
14719: IF l_update OR l_dml_operation <> 'UPDATE' THEN
14720: --UPD END
14721: hr_utility.set_location(' BEN_ENRLD_ANTHR_PTIP_RT_F UPDATE_ENRLD_ANTHR_PTIP_RT ',30);
14722: BEN_ENRLD_ANTHR_PTIP_RT_API.UPDATE_ENRLD_ANTHR_PTIP_RT(
14723: --
14724: P_VALIDATE => false
14725: ,P_EFFECTIVE_DATE => l_effective_date