eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_W2C_RPT dependencies on PER_ALL_ASSIGNMENTS_F

Line 53: 14-MAR-2006 ppanda 115.17 4583575 To reduce the shared memory per_all_assignments_f

49: use of bind Variable (:payroll_action_id)
50: 04-AUG-2005 pragupta 115.16 3679317 Change in procedure sort_action. Removed
51: +0 from paf and hou for removing FTS and
52: performance improvement
53: 14-MAR-2006 ppanda 115.17 4583575 To reduce the shared memory per_all_assignments_f
54: used instead of per_assignments_f.
55: 31-MAR-2006 sodhingr 115.18 5111088 removed the comment from sort_cursor to fix signal
56: 11 error.
57: 05-MAR-2009 asgugupt 115.19 6349762 Adding Order by clause in Range Cursor

Line 304: from per_all_assignments_f asg

300: if ln_person_id is not null then
301:
302: lv_sql_string :=
303: 'select distinct asg.person_id person_id
304: from per_all_assignments_f asg
305: where person_id = ' || ln_person_id ||
306: ' and :p_payroll_action_id is not null ';
307:
308: hr_utility.trace('Range for person_id not null');

Line 315: per_all_assignments_f paf

311:
312: lv_sql_string :=
313: 'select distinct paf.person_id
314: from hr_assignment_set_amendments asgset,
315: per_all_assignments_f paf
316: where assignment_set_id = ' || ln_asg_set || '
317: and asgset.assignment_id = paf.assignment_id
318: and asgset.include_or_exclude = ''I''
319: and :payroll_action_id is not null order by paf.person_id';

Line 414: per_all_assignments_f paf

410: ,cp_end_person in number
411: ,cp_asg_set in number) is
412: select distinct paf.person_id
413: from hr_assignment_set_amendments asgset,
414: per_all_assignments_f paf
415: where assignment_set_id = cp_asg_set
416: and asgset.include_or_exclude = 'I'
417: and paf.assignment_id = asgset.assignment_id
418: and paf.person_id between cp_start_person

Line 432: per_all_assignments_f paf

428: cp_tax_unit_id in number) IS
429: select distinct paf.person_id
430: from pay_assignment_actions paa,
431: pay_payroll_actions ppa,
432: per_all_assignments_f paf
433: where ppa.report_type = 'W-2C PAPER'
434: and ppa.report_category = 'REPORT'
435: and ppa.report_qualifier = 'DEFAULT'
436: and ppa.effective_date = add_months(cp_start_date,12) -1

Line 445: FROM per_all_assignments_f paf1

441: and paa.tax_unit_id = cp_tax_unit_id
442: and paf.assignment_id = paa.assignment_id
443: and paf.effective_end_date =
444: (SELECT max(paf1.effective_end_date)
445: FROM per_all_assignments_f paf1
446: WHERE paf1.assignment_id = paf.assignment_id
447: AND paf1.effective_start_date <= ppa.effective_date)
448: and paf.person_id between cp_start_person and cp_end_person;
449:

Line 462: per_all_assignments_f paf

458: select ppa.report_type, paa.assignment_id,
459: paa.assignment_action_id
460: from pay_payroll_actions ppa,
461: pay_assignment_actions paa,
462: per_all_assignments_f paf
463: where paa.assignment_id = paf.assignment_id
464: and paf.person_id = cp_person_id
465: and paf.effective_start_date <= cp_effective_date
466: and paf.effective_end_date >= cp_start_date

Line 474: FROM per_all_assignments_f paf1

470: and ppa.effective_date = cp_effective_date
471: and ppa.report_type in ('W2C_PRE_PROCESS','W2C_XML','W-2C PAPER')
472: and paf.effective_end_date =
473: (SELECT max(paf1.effective_end_date)
474: FROM per_all_assignments_f paf1
475: WHERE paf1.assignment_id = paf.assignment_id
476: AND paf1.effective_start_date <= ppa.effective_date)
477: order by paa.assignment_action_id desc;
478:

Line 488: per_all_assignments_f paf

484: select ppa.report_type, paa.assignment_id,
485: paa.assignment_action_id
486: from pay_payroll_actions ppa,
487: pay_assignment_actions paa,
488: per_all_assignments_f paf
489: where paa.assignment_id = paf.assignment_id
490: and paf.person_id = cp_person_id
491: and paf.effective_start_date <= cp_effective_date
492: and paf.effective_end_date >= cp_start_date

Line 503: FROM per_all_assignments_f paf1

499: and ppa.report_qualifier = 'FED'
500: and ppa.business_group_id = cp_business_group_id
501: and paf.effective_end_date =
502: (SELECT max(paf1.effective_end_date)
503: FROM per_all_assignments_f paf1
504: WHERE paf1.assignment_id = paf.assignment_id
505: AND paf1.effective_start_date <= ppa.effective_date)
506: and exists (select 1
507: from pay_action_interlocks pai,

Line 859: per_periods_of_service pps, per_all_assignments_f paf,

855: hr_utility.trace('Beginning of the sort_action cursor');
856: p_sql_string :=
857: 'select mt.rowid
858: from hr_organization_units hou, hr_locations_all hl,
859: per_periods_of_service pps, per_all_assignments_f paf,
860: pay_assignment_actions mt
861: where mt.payroll_action_id = :p_payroll_action_id
862: and paf.assignment_id = mt.assignment_id -- Bug 3679317 ( +0 removed)
863: and paf.effective_start_date = (select max(paf2.effective_start_date)

Line 864: from per_all_assignments_f paf2 where paf2.assignment_id = paf.assignment_id

860: pay_assignment_actions mt
861: where mt.payroll_action_id = :p_payroll_action_id
862: and paf.assignment_id = mt.assignment_id -- Bug 3679317 ( +0 removed)
863: and paf.effective_start_date = (select max(paf2.effective_start_date)
864: from per_all_assignments_f paf2 where paf2.assignment_id = paf.assignment_id
865: and paf2.effective_start_date <= to_date(''31-DEC-''||'''||l_year||''',''DD-MM-YYYY''))
866: and paf.effective_end_date >= to_date(''01-JAN-''||'''||l_year||''',''DD-MM-YYYY'')
867: and paf.assignment_type = ''E'' and hou.organization_id = paf.organization_id
868: and pps.period_of_service_id = paf.period_of_service_id