APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PER_ASSIGNMENTS_F

Line 263: from per_assignments_f PAF

259: c_date_earned in date,
260: c_date2_earned in date )
261: is
262: select max(PAF.effective_end_date)
263: from per_assignments_f PAF
264: where PAF.assignment_id = c_assignment_id
265: and PAF.payroll_id is not null
266: and PAF.effective_end_date
267: between trunc(c_date_earned,'Q') and c_date2_earned;

Line 274: from per_assignments_f PAF

270: c_date_earned in date,
271: c_date2_earned in date )
272: is
273: select max(PAF.effective_end_date)
274: from per_assignments_f PAF
275: where PAF.assignment_id = c_assignment_id
276: and PAF.payroll_id is not null
277: and PAF.effective_end_date
278: between trunc(c_date_earned,'Y') and c_date2_earned;

Line 568: from per_assignments_f paf

564: --
565: --hr_utility.set_location('bh_taxbal.get_virtual_date', 10);
566: select ''
567: into l_dummy
568: from per_assignments_f paf
569: where paf.assignment_id = p_assignment_id
570: and p_virtual_date between paf.effective_start_date
571: and paf.effective_end_date
572: and paf.payroll_id is not null;

Line 596: from per_assignments_f paf,

592: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 40);
593: --
594: select max(ppf.effective_end_date)
595: into l_virtual_date2
596: from per_assignments_f paf,
597: pay_payrolls_f ppf
598: where paf.assignment_id = p_assignment_id
599: and paf.payroll_id = ppf.payroll_id
600: and ppf.effective_end_date between

Line 2186: from per_assignments_f

2182: IF (l_assignment_id is not null and l_virtual_date is not null) THEN
2183: --
2184: select count(0)
2185: into l_asg_exists
2186: from per_assignments_f
2187: where assignment_id = l_assignment_id
2188: and l_virtual_date between effective_start_date and effective_end_date;
2189: --
2190: -- if assignment doesn't exist ...

Line 2200: from per_assignments_f

2196: -- get the termination date ...
2197: --
2198: select max(effective_end_date)
2199: into l_max_date
2200: from per_assignments_f
2201: where assignment_id = l_assignment_id;
2202: --
2203: -- get the date of the start of the time period in question
2204: --

Line 2217: per_assignments_f asg

2213: ELSIF p_time_type = 'PTD' THEN
2214: select tp.start_date
2215: into l_bal_start_date
2216: from per_time_periods tp,
2217: per_assignments_f asg
2218: where asg.assignment_id = l_assignment_id
2219: and l_max_date between asg.effective_start_date and effective_end_date
2220: and asg.payroll_id = tp.payroll_id
2221: and l_virtual_date between tp.start_date and tp.end_date;

Line 2430: from per_assignments_f paf

2426: --
2427: begin
2428: select 1
2429: into check_asg
2430: from per_assignments_f paf
2431: where paf.assignment_id = g_asgid_tbl_id(l_count)
2432: and p_virtual_date between paf.effective_start_date
2433: and paf.effective_end_date;
2434: --