DBA Data[Home] [Help]

APPS.BEN_ON_LINE_LF_EVT dependencies on PER_ALL_ASSIGNMENTS_F

Line 2485: from hr_locations_all loc,per_all_assignments_f asg

2481: l_asn per_asn%rowtype;
2482:
2483: Cursor c_state is
2484: select region_2
2485: from hr_locations_all loc,per_all_assignments_f asg
2486: where loc.location_id = asg.location_id
2487: and asg.person_id = p_person_id
2488: and asg.assignment_type <> 'C'
2489: and asg.primary_flag = 'Y'

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

3013: p_person_id in number
3014: ,p_assignment_id in number
3015: ,p_effective_date in date
3016: ,p_business_group_id in number
3017: ,p_offer_assignment_rec in per_all_assignments_f%rowtype) --bug 4621751 irec2
3018:
3019: is
3020: --
3021: l_proc varchar2(72) := g_package || 'p_manage_irec_life_events_w';