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_DETERMINE_VARIABLE_RATES dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 175: ,p_ast_row in per_assignment_status_types%rowtype

171: ,p_per_row in per_all_people_F%rowtype
172: := ben_determine_rates.g_def_curr_per_rec
173: ,p_asg_row in per_all_assignments_f%rowtype
174: := ben_determine_rates.g_def_curr_asg_rec
175: ,p_ast_row in per_assignment_status_types%rowtype
176: := ben_determine_rates.g_def_curr_ast_rec
177: ,p_adr_row in per_addresses%rowtype
178: := ben_determine_rates.g_def_curr_adr_rec
179: ,p_person_id IN number

Line 248: from per_all_assignments_f asg, per_assignment_status_types ast

244: --
245: -- FONM
246: cursor c_asg(cv_effective_date date) is
247: select asg.assignment_id,asg.organization_id
248: from per_all_assignments_f asg, per_assignment_status_types ast
249: where asg.person_id = p_person_id
250: and asg.assignment_type <> 'C'
251: and asg.primary_flag = 'Y'
252: and asg.assignment_status_type_id = ast.assignment_status_type_id(+)