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 194: ,p_ast_row in per_assignment_status_types%rowtype

190: ,p_per_row in per_all_people_F%rowtype
191: := ben_determine_rates.g_def_curr_per_rec
192: ,p_asg_row in per_all_assignments_f%rowtype
193: := ben_determine_rates.g_def_curr_asg_rec
194: ,p_ast_row in per_assignment_status_types%rowtype
195: := ben_determine_rates.g_def_curr_ast_rec
196: ,p_adr_row in per_addresses%rowtype
197: := ben_determine_rates.g_def_curr_adr_rec
198: ,p_person_id IN number

Line 268: from per_all_assignments_f asg, per_assignment_status_types ast

264: --
265: -- FONM
266: cursor c_asg(cv_effective_date date) is
267: select asg.assignment_id,asg.organization_id
268: from per_all_assignments_f asg, per_assignment_status_types ast
269: where asg.person_id = p_person_id
270: and ((asg.assignment_type <> 'C'
271: and asg.primary_flag = 'Y'
272: and 'IREC' <> ( select ler.typ_cd