APPS.PER_ABSENCE_ATTENDANCES_PKG dependencies on PER_ASSIGNMENTS

Line 2015: per_assignments_f asg

2011: --
2012: cursor c4 is
2013: select 1
2014: from hr_positions_f pp,
2015: per_assignments_f asg
2016: where asg.person_id = p_psn_id
2017: and nvl(p_dstart,nvl(p_proj_start,p_sess)) between
2018: asg.effective_start_date and asg.effective_end_date
2019: and pp.position_id = asg.position_id

Line 2285: per_assignments_f a

2281: t.start_date,
2282: t.end_date
2283: from per_time_periods t,
2284: pay_element_entries_f e,
2285: per_assignments_f a
2286: where a.person_id = p_per_id
2287: and a.primary_flag = 'Y'
2288: and p_sdstart between a.effective_start_date and a.effective_end_date
2289: and e.assignment_id = a.assignment_id

Line 2403: from per_assignments_f asg,

2399: select asg.assignment_id,
2400: l.element_link_id,
2401: asg.payroll_id,
2402: 'X'
2403: from per_assignments_f asg,
2404: pay_element_types_f t,
2405: pay_element_links_f l
2406: where l.business_group_id + 0 = p_bgroup_id
2407: and t.element_type_id = p_eltype

Line 2531: from per_assignments

2527: and ue.creator_id = p_abat_type;
2528: --
2529: cursor c20 is
2530: select assignment_id
2531: from per_assignments
2532: where person_id = p_per_id
2533: and primary_flag = 'Y';
2534: --
2535: begin

Line 2751: from per_assignments

2747: p_test IN OUT NOCOPY VARCHAR2) is
2748:
2749: cursor c22 is
2750: select 'Y'
2751: from per_assignments
2752: where primary_flag = 'Y'
2753: and person_id = p_per_id
2754: and payroll_id is not null;
2755: --