APPS.PAY_US_TAXBAL_VIEW_PKG dependencies on PER_ASSIGNMENTS_F

Line 232: from per_assignments_f PAF

228: c_date_earned in date,
229: c_date2_earned in date )
230: is
231: select max(PAF.effective_end_date)
232: from per_assignments_f PAF
233: where PAF.assignment_id = c_assignment_id
234: and PAF.payroll_id is not null
235: and PAF.effective_end_date
236: between trunc(c_date_earned,'Q') and c_date2_earned;

Line 243: from per_assignments_f PAF

239: c_date_earned in date,
240: c_date2_earned in date )
241: is
242: select max(PAF.effective_end_date)
243: from per_assignments_f PAF
244: where PAF.assignment_id = c_assignment_id
245: and PAF.payroll_id is not null
246: and PAF.effective_end_date
247: between trunc(c_date_earned,'Y') and c_date2_earned;

Line 537: from per_assignments_f paf

533: --
534: --hr_utility.set_location('bh_taxbal.get_virtual_date', 10);
535: select ''
536: into l_dummy
537: from per_assignments_f paf
538: where paf.assignment_id = p_assignment_id
539: and p_virtual_date between paf.effective_start_date
540: and paf.effective_end_date
541: and paf.payroll_id is not null;

Line 565: from per_assignments_f paf,

561: --hr_utility.set_location( 'bh_taxbal.get_virtual_date', 40);
562: --
563: select max(ppf.effective_end_date)
564: into l_virtual_date2
565: from per_assignments_f paf,
566: pay_payrolls_f ppf
567: where paf.assignment_id = p_assignment_id
568: and paf.payroll_id = ppf.payroll_id
569: and ppf.effective_end_date between

Line 1948: from per_assignments_f

1944: IF (l_assignment_id is not null and l_virtual_date is not null) THEN
1945: --
1946: select count(0)
1947: into l_asg_exists
1948: from per_assignments_f
1949: where assignment_id = l_assignment_id
1950: and l_virtual_date between effective_start_date and effective_end_date;
1951: --
1952: -- if assignment doesn't exist ...

Line 1962: from per_assignments_f

1958: -- get the termination date ...
1959: --
1960: select max(effective_end_date)
1961: into l_max_date
1962: from per_assignments_f
1963: where assignment_id = l_assignment_id;
1964: --
1965: -- get the date of the start of the time period in question
1966: --

Line 1979: per_assignments_f asg

1975: ELSIF p_time_type = 'PTD' THEN
1976: select tp.start_date
1977: into l_bal_start_date
1978: from per_time_periods tp,
1979: per_assignments_f asg
1980: where asg.assignment_id = l_assignment_id
1981: and l_max_date between asg.effective_start_date and effective_end_date
1982: and asg.payroll_id = tp.payroll_id
1983: and l_virtual_date between tp.start_date and tp.end_date;

Line 2169: from per_assignments_f paf

2165: --
2166: begin
2167: select 1
2168: into check_asg
2169: from per_assignments_f paf
2170: where paf.assignment_id = g_asgid_tbl_id(l_count)
2171: and p_virtual_date between paf.effective_start_date
2172: and paf.effective_end_date;
2173: --