eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PD_COPY_TO_BEN_FOUR dependencies on BEN_ELIGY_PRFL_RL_F

Line 6867: -- and tr.where_clause = l_BEN_ELIGY_PRFL_RL_F

6863: ,cpe.dml_operation,cpe.datetrack_mode from ben_copy_entity_results cpe,
6864: pqh_table_route tr
6865: where cpe.copy_entity_txn_id = p_copy_entity_txn_id
6866: and cpe.table_route_id = tr.table_route_id
6867: -- and tr.where_clause = l_BEN_ELIGY_PRFL_RL_F
6868: and tr.table_alias = l_table_alias
6869: and cpe.number_of_copies = 1 -- ADDITION
6870: group by cpe.information1,cpe.information2,cpe.information3, cpe.table_route_id,cpe.dml_operation,cpe.datetrack_mode
6871: order by information1, information2; --added for bug: 5151945

Line 6905: from BEN_ELIGY_PRFL_RL_F ERL

6901: c_business_group_id number,
6902: c_new_pk_id number) is
6903: select
6904: ERL.eligy_prfl_rl_id new_value
6905: from BEN_ELIGY_PRFL_RL_F ERL
6906: where
6907: ERL.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
6908: ERL.FORMULA_ID = l_FORMULA_ID and
6909: ERL.ORDR_TO_APLY_NUM = l_ORDR_TO_APLY_NUM and -- IK Added

Line 6917: from BEN_ELIGY_PRFL_RL_F ERL1

6913: and effective_end_date ;
6914: --END TEMPIK
6915: /*TEMPIK
6916: and exists ( select null
6917: from BEN_ELIGY_PRFL_RL_F ERL1
6918: where
6919: ERL1.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
6920: ERL1.FORMULA_ID = l_FORMULA_ID and
6921: ERL1.ORDR_TO_APLY_NUM = l_ORDR_TO_APLY_NUM and -- IK Added

Line 6925: from BEN_ELIGY_PRFL_RL_F ERL2

6921: ERL1.ORDR_TO_APLY_NUM = l_ORDR_TO_APLY_NUM and -- IK Added
6922: ERL1.business_group_id = c_business_group_id
6923: and ERL1.effective_start_date <= c_effective_start_date )
6924: and exists ( select null
6925: from BEN_ELIGY_PRFL_RL_F ERL2
6926: where
6927: ERL2.ELIGY_PRFL_ID = l_ELIGY_PRFL_ID and
6928: ERL2.FORMULA_ID = l_FORMULA_ID and
6929: ERL2.ORDR_TO_APLY_NUM = l_ORDR_TO_APLY_NUM and -- IK Added

Line 7084: (p_base_table_name => 'BEN_ELIGY_PRFL_RL_F',

7080: if c_find_ERL_in_target%found then
7081: --
7082: --TEMPIK
7083: l_dt_rec_found := dt_api.check_min_max_dates
7084: (p_base_table_name => 'BEN_ELIGY_PRFL_RL_F',
7085: p_base_key_column => 'ELIGY_PRFL_RL_ID',
7086: p_base_key_value => l_new_value,
7087: p_from_date => l_min_esd,
7088: p_to_date => l_max_eed );

Line 7144: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);

7140: end if;
7141:
7142: if l_first_rec and not l_update then
7143: -- Call Create routine.
7144: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F CREATE_ELIGY_PROFILE_RULE ',20);
7145: BEN_ELIGY_PROFILE_RULE_API.CREATE_ELIGY_PROFILE_RULE(
7146: --
7147: P_VALIDATE => false
7148: ,P_EFFECTIVE_DATE => l_effective_date

Line 7219: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F UPDATE_ELIGY_PROFILE_RULE ',30);

7215: else
7216: --
7217: -- Call Update routine for the pk_id created in prev run .
7218: -- insert the table_name,old_pk_id,new_pk_id into a plsql record
7219: hr_utility.set_location(' BEN_ELIGY_PRFL_RL_F UPDATE_ELIGY_PROFILE_RULE ',30);
7220: --UPD START
7221: hr_utility.set_location('Before call to get_dt_modes l_dt_mode'||l_datetrack_mode,5);
7222: --
7223: if l_update then