APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_ENRLD_ANTHR_PL_RT_F

Line 14836: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PL_RT_F

14832: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
14833: pqh_table_route tr
14834: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
14835: and cpe.table_route_id = tr.table_route_id
14836: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PL_RT_F
14837: and tr.table_alias = l_table_alias
14838: and cpe.number_of_copies = 1 -- ADDITION
14839: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
14840: order by information1, information2; --added for bug: 5151945

Line 14874: from BEN_ENRLD_ANTHR_PL_RT_F ENL

14870: c_business_group_id number,
14871: c_new_pk_id number) is
14872: select
14873: ENL.enrld_anthr_pl_rt_id new_value
14874: from BEN_ENRLD_ANTHR_PL_RT_F ENL
14875: where
14876: ENL.PL_ID = l_PL_ID and
14877: ENL.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14878: ENL.business_group_id = c_business_group_id

Line 14886: from BEN_ENRLD_ANTHR_PL_RT_F ENL1

14882: and effective_end_date ;
14883: --END TEMPIK
14884: /*TEMPIK
14885: and exists ( select null
14886: from BEN_ENRLD_ANTHR_PL_RT_F ENL1
14887: where
14888: ENL1.PL_ID = l_PL_ID and
14889: ENL1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14890: ENL1.business_group_id = c_business_group_id

Line 14893: from BEN_ENRLD_ANTHR_PL_RT_F ENL2

14889: ENL1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14890: ENL1.business_group_id = c_business_group_id
14891: and ENL1.effective_start_date <= c_effective_start_date )
14892: and exists ( select null
14893: from BEN_ENRLD_ANTHR_PL_RT_F ENL2
14894: where
14895: ENL2.PL_ID = l_PL_ID and
14896: ENL2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
14897: ENL2.business_group_id = c_business_group_id

Line 15032: (p_base_table_name => 'BEN_ENRLD_ANTHR_PL_RT_F',

15028: if c_find_ENL_in_target%found then
15029: --
15030: --TEMPIK
15031: l_dt_rec_found := dt_api.check_min_max_dates
15032: (p_base_table_name => 'BEN_ENRLD_ANTHR_PL_RT_F',
15033: p_base_key_column => 'ENRLD_ANTHR_PL_RT_ID',
15034: p_base_key_value => l_new_value,
15035: p_from_date => l_min_esd,
15036: p_to_date => l_max_eed );

Line 15090: hr_utility.set_location(' BEN_ENRLD_ANTHR_PL_RT_F CREATE_ENRLD_ANTHR_PL_RT ',20);

15086: end if;
15087:
15088: if l_first_rec and not l_update then
15089: -- Call Create routine.
15090: hr_utility.set_location(' BEN_ENRLD_ANTHR_PL_RT_F CREATE_ENRLD_ANTHR_PL_RT ',20);
15091: BEN_ENRLD_ANTHR_PL_RT_API.CREATE_ENRLD_ANTHR_PL_RT(
15092: --
15093: P_VALIDATE => false
15094: ,P_EFFECTIVE_DATE => l_effective_date

Line 15183: hr_utility.set_location(' BEN_ENRLD_ANTHR_PL_RT_F UPDATE_ENRLD_ANTHR_PL_RT ',30);

15179: hr_utility.set_location('After call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
15180: --
15181: IF l_update OR l_dml_operation <> 'UPDATE' THEN
15182: --UPD END
15183: hr_utility.set_location(' BEN_ENRLD_ANTHR_PL_RT_F UPDATE_ENRLD_ANTHR_PL_RT ',30);
15184: BEN_ENRLD_ANTHR_PL_RT_API.UPDATE_ENRLD_ANTHR_PL_RT(
15185: --
15186: P_VALIDATE => false
15187: ,P_EFFECTIVE_DATE => l_effective_date