APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on PER_ALL_ASSIGNMENTS_F

Line 233: from hr_locations_all loc,per_all_assignments_f asg

229: l_package varchar2(80) := g_package||'.compute_premium';
230: -- fonm new p_date param added
231: Cursor c_state (p_date date) is
232: select region_2
233: from hr_locations_all loc,per_all_assignments_f asg
234: where loc.location_id = asg.location_id
235: and asg.person_id = p_person_id
236: and asg.assignment_type <> 'C'
237: and asg.primary_flag = 'Y'

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

242: --
243: -- fonm new p_date param added
244: cursor c_asg(p_date date) is
245: select asg.assignment_id,asg.organization_id,loc.region_2
246: from per_all_assignments_f asg,hr_locations_all loc, per_assignment_status_types ast
247: where asg.person_id = p_person_id
248: and asg.assignment_type <> 'C'
249: and asg.primary_flag = 'Y'
250: and asg.location_id = loc.location_id(+)

Line 768: l_fonm_ass_rec per_all_assignments_f%rowtype;

764: l_fonm_cvg_strt_dt date ;
765: l_fonm_rt_strt_dt date ;
766: l_dummy_d date ;
767: l_fonm_per_rec per_all_people_f%rowtype;
768: l_fonm_ass_rec per_all_assignments_f%rowtype;
769: l_comp_prem_idx number;
770: l_dflt_value number;
771:
772: -- Eof FONM