APPS.PAY_US_TAX_BALS_PKG dependencies on PER_ASSIGNMENTS_F

Line 242: from per_assignments_f paf

238: --
239: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date', 10);
240: select ''
241: into l_dummy
242: from per_assignments_f paf
243: where paf.assignment_id = p_assignment_id
244: and p_virtual_date between paf.effective_start_date
245: and paf.effective_end_date
246: and paf.payroll_id is not null;

Line 280: from per_assignments_f paf,

276: dbms_sql.column_value (sql_cursor, 1, l_virtual_date);
277: --
278: select max(ppf.effective_end_date)
279: into l_virtual_date2
280: from per_assignments_f paf,
281: pay_payrolls_f ppf
282: where paf.assignment_id = p_assignment_id
283: and paf.payroll_id = ppf.payroll_id
284: and ppf.effective_end_date between

Line 1070: from per_assignments_f

1066: IF (l_assignment_id is not null and l_virtual_date is not null) THEN
1067: --
1068: select count(0)
1069: into l_asg_exists
1070: from per_assignments_f
1071: where assignment_id = l_assignment_id
1072: and l_virtual_date between effective_start_date and effective_end_date;
1073: --
1074: -- if assignment doesn't exist ...

Line 1084: from per_assignments_f

1080: -- get the termination date ...
1081: --
1082: select max(effective_end_date)
1083: into l_max_date
1084: from per_assignments_f
1085: where assignment_id = l_assignment_id;
1086: --
1087: -- get the date of the start of the time period in question
1088: --

Line 1101: per_assignments_f asg

1097: ELSIF p_time_type = 'PTD' THEN
1098: select tp.start_date
1099: into l_bal_start_date
1100: from per_time_periods tp,
1101: per_assignments_f asg
1102: where asg.assignment_id = l_assignment_id
1103: and l_max_date between asg.effective_start_date and effective_end_date
1104: and asg.payroll_id = tp.payroll_id
1105: and l_virtual_date between tp.start_date and tp.end_date;

Line 1276: from per_assignments_f paf

1272: --
1273: begin
1274: select 1
1275: into check_asg
1276: from per_assignments_f paf
1277: where paf.assignment_id = g_asgid_tbl_id(l_count)
1278: and l_virtual_date between paf.effective_start_date
1279: and paf.effective_end_date;
1280: --

Line 2081: 'from per_assignments_f PAF ' ||

2077: 'and PPA.effective_date <= ' ||
2078: ':DATE2_EARNED ' ||
2079: 'and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') ';
2080: g_dim_tbl_vtd(0) := 'select max(PAF.effective_end_date) ' ||
2081: 'from per_assignments_f PAF ' ||
2082: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2083: 'and PAF.payroll_id is not null ' ||
2084: 'and PAF.effective_end_date between ' ||
2085: ' trunc(:DATE_EARNED,''Q'') and ' ||

Line 2106: 'from per_assignments_f PAF ' ||

2102: 'and PPA.effective_date <= ' ||
2103: ':DATE2_EARNED ' ||
2104: 'and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') ';
2105: g_dim_tbl_vtd(1) := 'select max(PAF.effective_end_date) ' ||
2106: 'from per_assignments_f PAF ' ||
2107: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2108: 'and PAF.payroll_id is not null ' ||
2109: 'and PAF.effective_end_date between ' ||
2110: ' trunc(:DATE_EARNED,''Y'') and ' ||

Line 2131: 'from per_assignments_f PAF ' ||

2127: 'and PPA.effective_date <= ' ||
2128: ':DATE2_EARNED ' ||
2129: 'and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') ';
2130: g_dim_tbl_vtd(2) := 'select max(PAF.effective_end_date) ' ||
2131: 'from per_assignments_f PAF ' ||
2132: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2133: 'and PAF.payroll_id is not null ' ||
2134: 'and PAF.effective_end_date between ' ||
2135: ' trunc(:DATE_EARNED,''Y'') and ' ||

Line 2169: 'from per_assignments_f PAF ' ||

2165: ' and PPA.effective_date <= ' ||
2166: ':DATE2_EARNED ' ||
2167: ' and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') )';
2168: g_dim_tbl_vtd(3) := 'select max(PAF.effective_end_date) ' ||
2169: 'from per_assignments_f PAF ' ||
2170: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2171: 'and PAF.payroll_id is not null ' ||
2172: 'and PAF.effective_end_date between ' ||
2173: ' trunc(:DATE_EARNED,''Y'') and ' ||