DBA Data[Home] [Help]

APPS.BEN_ON_LINE_LF_EVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 2473: from hr_locations_all loc,per_all_assignments_f asg

2469: l_asn per_asn%rowtype;
2470:
2471: Cursor c_state is
2472: select region_2
2473: from hr_locations_all loc,per_all_assignments_f asg
2474: where loc.location_id = asg.location_id
2475: and asg.person_id = p_person_id
2476: and asg.assignment_type <> 'C'
2477: and asg.primary_flag = 'Y'

Line 2967: ,p_offer_assignment_rec in per_all_assignments_f%rowtype) --bug 4621751 irec2

2963: p_person_id in number
2964: ,p_assignment_id in number
2965: ,p_effective_date in date
2966: ,p_business_group_id in number
2967: ,p_offer_assignment_rec in per_all_assignments_f%rowtype) --bug 4621751 irec2
2968:
2969: is
2970: --
2971: l_proc varchar2(72) := g_package || 'p_manage_irec_life_events_w';