APPS.PAY_US_TAX_BALS_PKG dependencies on PER_ASSIGNMENTS_F

Line 255: from per_assignments_f paf

251: --
252: hr_utility.set_location('pay_us_tax_bals_pkg.get_virtual_date', 10);
253: select ''
254: into l_dummy
255: from per_assignments_f paf
256: where paf.assignment_id = p_assignment_id
257: and p_virtual_date between paf.effective_start_date
258: and paf.effective_end_date
259: and paf.payroll_id is not null;

Line 293: from per_assignments_f paf,

289: dbms_sql.column_value (sql_cursor, 1, l_virtual_date);
290: --
291: select max(ppf.effective_end_date)
292: into l_virtual_date2
293: from per_assignments_f paf,
294: pay_payrolls_f ppf
295: where paf.assignment_id = p_assignment_id
296: and paf.payroll_id = ppf.payroll_id
297: and ppf.effective_end_date between

Line 1139: from per_assignments_f

1135: IF (l_assignment_id is not null and l_virtual_date is not null) THEN
1136: --
1137: select count(0)
1138: into l_asg_exists
1139: from per_assignments_f
1140: where assignment_id = l_assignment_id
1141: and l_virtual_date between effective_start_date and effective_end_date;
1142: --
1143: -- if assignment doesn't exist ...

Line 1153: from per_assignments_f

1149: -- get the termination date ...
1150: --
1151: select max(effective_end_date)
1152: into l_max_date
1153: from per_assignments_f
1154: where assignment_id = l_assignment_id;
1155: --
1156: -- get the date of the start of the time period in question
1157: --

Line 1170: per_assignments_f asg

1166: ELSIF p_time_type = 'PTD' THEN
1167: select tp.start_date
1168: into l_bal_start_date
1169: from per_time_periods tp,
1170: per_assignments_f asg
1171: where asg.assignment_id = l_assignment_id
1172: and l_max_date between asg.effective_start_date and effective_end_date
1173: and asg.payroll_id = tp.payroll_id
1174: and l_virtual_date between tp.start_date and tp.end_date;

Line 1367: from per_assignments_f paf

1363: --
1364: begin
1365: select 1
1366: into check_asg
1367: from per_assignments_f paf
1368: where paf.assignment_id = g_asgid_tbl_id(l_count)
1369: and l_virtual_date between paf.effective_start_date
1370: and paf.effective_end_date;
1371: --

Line 2380: 'from per_assignments_f PAF ' ||

2376: 'and PPA.effective_date <= ' ||
2377: ':DATE2_EARNED ' ||
2378: 'and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') ';
2379: g_dim_tbl_vtd(0) := 'select max(PAF.effective_end_date) ' ||
2380: 'from per_assignments_f PAF ' ||
2381: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2382: 'and PAF.payroll_id is not null ' ||
2383: 'and PAF.effective_end_date between ' ||
2384: ' trunc(:DATE_EARNED,''Q'') and ' ||

Line 2405: 'from per_assignments_f PAF ' ||

2401: 'and PPA.effective_date <= ' ||
2402: ':DATE2_EARNED ' ||
2403: 'and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') ';
2404: g_dim_tbl_vtd(1) := 'select max(PAF.effective_end_date) ' ||
2405: 'from per_assignments_f PAF ' ||
2406: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2407: 'and PAF.payroll_id is not null ' ||
2408: 'and PAF.effective_end_date between ' ||
2409: ' trunc(:DATE_EARNED,''Y'') and ' ||

Line 2430: 'from per_assignments_f PAF ' ||

2426: 'and PPA.effective_date <= ' ||
2427: ':DATE2_EARNED ' ||
2428: 'and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') ';
2429: g_dim_tbl_vtd(2) := 'select max(PAF.effective_end_date) ' ||
2430: 'from per_assignments_f PAF ' ||
2431: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2432: 'and PAF.payroll_id is not null ' ||
2433: 'and PAF.effective_end_date between ' ||
2434: ' trunc(:DATE_EARNED,''Y'') and ' ||

Line 2468: 'from per_assignments_f PAF ' ||

2464: ' and PPA.effective_date <= ' ||
2465: ':DATE2_EARNED ' ||
2466: ' and PPA.action_type in (''R'',''Q'',''I'',''B'',''V'') )';
2467: g_dim_tbl_vtd(3) := 'select max(PAF.effective_end_date) ' ||
2468: 'from per_assignments_f PAF ' ||
2469: 'where PAF.assignment_id = :ASSIGNMENT_ID ' ||
2470: 'and PAF.payroll_id is not null ' ||
2471: 'and PAF.effective_end_date between ' ||
2472: ' trunc(:DATE_EARNED,''Y'') and ' ||