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_ACTUAL_PREMIUM dependencies on PER_ALL_ASSIGNMENTS_F

Line 225: from hr_locations_all loc,per_all_assignments_f asg

221: l_package varchar2(80) := g_package||'.compute_premium';
222: -- fonm new p_date param added
223: Cursor c_state (p_date date) is
224: select region_2
225: from hr_locations_all loc,per_all_assignments_f asg
226: where loc.location_id = asg.location_id
227: and asg.person_id = p_person_id
228: and asg.assignment_type <> 'C'
229: and asg.primary_flag = 'Y'

Line 238: from per_all_assignments_f asg,hr_locations_all loc, per_assignment_status_types ast

234: --
235: -- fonm new p_date param added
236: cursor c_asg(p_date date) is
237: select asg.assignment_id,asg.organization_id,loc.region_2
238: from per_all_assignments_f asg,hr_locations_all loc, per_assignment_status_types ast
239: where asg.person_id = p_person_id
240: and asg.assignment_type <> 'C'
241: and asg.primary_flag = 'Y'
242: and asg.location_id = loc.location_id(+)

Line 725: l_fonm_ass_rec per_all_assignments_f%rowtype;

721: l_fonm_cvg_strt_dt date ;
722: l_fonm_rt_strt_dt date ;
723: l_dummy_d date ;
724: l_fonm_per_rec per_all_people_f%rowtype;
725: l_fonm_ass_rec per_all_assignments_f%rowtype;
726: l_comp_prem_idx number;
727:
728: -- Eof FONM
729: