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_PER_ASG_ELIG dependencies on BEN_ELIG_RSLT_F

Line 80: from ben_elig_rslt_f

76: elig_flag,
77: object_version_number,
78: effective_start_date,
79: effective_end_date
80: from ben_elig_rslt_f
81: where elig_obj_id = p_elig_obj_id
82: and person_id = c_person_id
83: and nvl(assignment_id,-1) = nvl(c_assignment_id,-1)
84: and c_effective_date between effective_start_date

Line 92: from ben_elig_rslt_f

88: cursor c_chk_future_rslt(c_person_id number,
89: c_assignment_id number,
90: c_effective_date date) is
91: select min(effective_start_date)
92: from ben_elig_rslt_f
93: where elig_obj_id = p_elig_obj_id
94: and person_id = c_person_id
95: and nvl(assignment_id,-1) = nvl(c_assignment_id,-1)
96: and effective_start_date > c_effective_date;

Line 308: p_base_table_name => 'BEN_ELIG_RSLT_F',

304: elsif l_elig_flag <> l_elig_rslt_rec.elig_flag then
305:
306: dt_api.find_dt_upd_modes
307: (p_effective_date => p_effective_date,
308: p_base_table_name => 'BEN_ELIG_RSLT_F',
309: p_base_key_column => 'elig_rslt_id',
310: p_base_key_value => l_elig_rslt_rec.elig_rslt_id,
311: p_correction => l_correction,
312: p_update => l_update,