APPS.BEN_PD_COPY_TO_BEN_THREE dependencies on BEN_ENRLD_ANTHR_PGM_RT_F

Line 13912: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PGM_RT_F

13908: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
13909: pqh_table_route tr
13910: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
13911: and cpe.table_route_id = tr.table_route_id
13912: -- and tr.where_clause = l_BEN_ENRLD_ANTHR_PGM_RT_F
13913: and tr.table_alias = l_table_alias
13914: and cpe.number_of_copies = 1 -- ADDITION
13915: group by cpe.information1,cpe.information2,cpe.information3,cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
13916: order by information1, information2; --added for bug: 5151945

Line 13950: from BEN_ENRLD_ANTHR_PGM_RT_F EPM

13946: c_business_group_id number,
13947: c_new_pk_id number) is
13948: select
13949: EPM.enrld_anthr_pgm_rt_id new_value
13950: from BEN_ENRLD_ANTHR_PGM_RT_F EPM
13951: where
13952: EPM.PGM_ID = l_PGM_ID and
13953: EPM.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
13954: EPM.business_group_id = c_business_group_id

Line 13962: from BEN_ENRLD_ANTHR_PGM_RT_F EPM1

13958: and effective_end_date ;
13959: --END TEMPIK
13960: /*TEMPIK
13961: and exists ( select null
13962: from BEN_ENRLD_ANTHR_PGM_RT_F EPM1
13963: where
13964: EPM1.PGM_ID = l_PGM_ID and
13965: EPM1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
13966: EPM1.business_group_id = c_business_group_id

Line 13969: from BEN_ENRLD_ANTHR_PGM_RT_F EPM2

13965: EPM1.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
13966: EPM1.business_group_id = c_business_group_id
13967: and EPM1.effective_start_date <= c_effective_start_date )
13968: and exists ( select null
13969: from BEN_ENRLD_ANTHR_PGM_RT_F EPM2
13970: where
13971: EPM2.PGM_ID = l_PGM_ID and
13972: EPM2.VRBL_RT_PRFL_ID = l_VRBL_RT_PRFL_ID and
13973: EPM2.business_group_id = c_business_group_id

Line 14108: (p_base_table_name => 'BEN_ENRLD_ANTHR_PGM_RT_F',

14104: if c_find_EPM_in_target%found then
14105: --
14106: --TEMPIK
14107: l_dt_rec_found := dt_api.check_min_max_dates
14108: (p_base_table_name => 'BEN_ENRLD_ANTHR_PGM_RT_F',
14109: p_base_key_column => 'ENRLD_ANTHR_PGM_RT_ID',
14110: p_base_key_value => l_new_value,
14111: p_from_date => l_min_esd,
14112: p_to_date => l_max_eed );

Line 14166: hr_utility.set_location(' BEN_ENRLD_ANTHR_PGM_RT_F CREATE_ENRLD_ANTHR_PGM_RT ',20);

14162: end if;
14163:
14164: if l_first_rec and not l_update then
14165: -- Call Create routine.
14166: hr_utility.set_location(' BEN_ENRLD_ANTHR_PGM_RT_F CREATE_ENRLD_ANTHR_PGM_RT ',20);
14167: BEN_ENRLD_ANTHR_PGM_RT_API.CREATE_ENRLD_ANTHR_PGM_RT(
14168: --
14169: P_VALIDATE => false
14170: ,P_EFFECTIVE_DATE => l_effective_date

Line 14259: hr_utility.set_location(' BEN_ENRLD_ANTHR_PGM_RT_F UPDATE_ENRLD_ANTHR_PGM_RT ',30);

14255: --
14256: IF l_update OR l_dml_operation <> 'UPDATE' THEN
14257: --UPD END
14258: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
14259: hr_utility.set_location(' BEN_ENRLD_ANTHR_PGM_RT_F UPDATE_ENRLD_ANTHR_PGM_RT ',30);
14260: BEN_ENRLD_ANTHR_PGM_RT_API.UPDATE_ENRLD_ANTHR_PGM_RT(
14261: --
14262: P_VALIDATE => false
14263: ,P_EFFECTIVE_DATE => l_effective_date