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: *****************************************************************************/

Line 258: from per_all_assignments_f asg

254: if ln_person_id is not null then
255:
256: lv_sql_string :=
257: 'select distinct asg.person_id person_id
258: from per_all_assignments_f asg
259: where person_id = ' || ln_person_id ||
260: ' and :p_payroll_action_id is not null ';
261:
262: hr_utility.trace('Range for person_id not null');

Line 269: per_all_assignments_f paf

265:
266: lv_sql_string :=
267: 'select distinct paf.person_id
268: from hr_assignment_set_amendments asgset,
269: per_all_assignments_f paf
270: where assignment_set_id = ' || ln_asg_set || '
271: and asgset.assignment_id = paf.assignment_id
272: and asgset.include_or_exclude = ''I''
273: and :payroll_action_id is not null ';

Line 368: per_all_assignments_f paf

364: ,cp_end_person in number
365: ,cp_asg_set in number) is
366: select distinct paf.person_id
367: from hr_assignment_set_amendments asgset,
368: per_all_assignments_f paf
369: where assignment_set_id = cp_asg_set
370: and asgset.include_or_exclude = 'I'
371: and paf.assignment_id = asgset.assignment_id
372: and paf.person_id between cp_start_person

Line 386: per_all_assignments_f paf

382: cp_tax_unit_id in number) IS
383: select distinct paf.person_id
384: from pay_assignment_actions paa,
385: pay_payroll_actions ppa,
386: per_all_assignments_f paf
387: where ppa.report_type = 'W-2C PAPER'
388: and ppa.report_category = 'REPORT'
389: and ppa.report_qualifier = 'DEFAULT'
390: and ppa.effective_date = add_months(cp_start_date,12) -1

Line 399: FROM per_all_assignments_f paf1

395: and paa.tax_unit_id = cp_tax_unit_id
396: and paf.assignment_id = paa.assignment_id
397: and paf.effective_end_date =
398: (SELECT max(paf1.effective_end_date)
399: FROM per_all_assignments_f paf1
400: WHERE paf1.assignment_id = paf.assignment_id
401: AND paf1.effective_start_date <= ppa.effective_date)
402: and paf.person_id between cp_start_person and cp_end_person;
403:

Line 416: per_all_assignments_f paf

412: select ppa.report_type, paa.assignment_id,
413: paa.assignment_action_id
414: from pay_payroll_actions ppa,
415: pay_assignment_actions paa,
416: per_all_assignments_f paf
417: where paa.assignment_id = paf.assignment_id
418: and paf.person_id = cp_person_id
419: and paf.effective_start_date <= cp_effective_date
420: and paf.effective_end_date >= cp_start_date

Line 428: FROM per_all_assignments_f paf1

424: and ppa.effective_date = cp_effective_date
425: and ppa.report_type in ('W2C_PRE_PROCESS','W-2C PAPER')
426: and paf.effective_end_date =
427: (SELECT max(paf1.effective_end_date)
428: FROM per_all_assignments_f paf1
429: WHERE paf1.assignment_id = paf.assignment_id
430: AND paf1.effective_start_date <= ppa.effective_date)
431: order by paa.assignment_action_id desc;
432:

Line 442: per_all_assignments_f paf

438: select ppa.report_type, paa.assignment_id,
439: paa.assignment_action_id
440: from pay_payroll_actions ppa,
441: pay_assignment_actions paa,
442: per_all_assignments_f paf
443: where paa.assignment_id = paf.assignment_id
444: and paf.person_id = cp_person_id
445: and paf.effective_start_date <= cp_effective_date
446: and paf.effective_end_date >= cp_start_date

Line 457: FROM per_all_assignments_f paf1

453: and ppa.report_qualifier = 'FED'
454: and ppa.business_group_id = cp_business_group_id
455: and paf.effective_end_date =
456: (SELECT max(paf1.effective_end_date)
457: FROM per_all_assignments_f paf1
458: WHERE paf1.assignment_id = paf.assignment_id
459: AND paf1.effective_start_date <= ppa.effective_date)
460: and exists (select 1
461: from pay_action_interlocks pai,

Line 801: per_periods_of_service pps, per_all_assignments_f paf,

797: hr_utility.trace('Beginning of the sort_action cursor');
798: p_sql_string :=
799: 'select mt.rowid
800: from hr_organization_units hou, hr_locations_all hl,
801: per_periods_of_service pps, per_all_assignments_f paf,
802: pay_assignment_actions mt
803: where mt.payroll_action_id = :p_payroll_action_id
804: and paf.assignment_id = mt.assignment_id -- Bug 3679317 ( +0 removed)
805: and paf.effective_start_date = (select max(paf2.effective_start_date)

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

802: pay_assignment_actions mt
803: where mt.payroll_action_id = :p_payroll_action_id
804: and paf.assignment_id = mt.assignment_id -- Bug 3679317 ( +0 removed)
805: and paf.effective_start_date = (select max(paf2.effective_start_date)
806: from per_all_assignments_f paf2 where paf2.assignment_id = paf.assignment_id
807: and paf2.effective_start_date <= to_date(''' || to_char(ld_end_date,'dd-mon-yyyy') || ''',''dd-mon-yyyy''))
808: and paf.effective_end_date >= to_date('''|| to_char(ld_start_date,'dd-mon-yyyy') ||''',''dd-mon-yyyy'')
809: and paf.assignment_type = ''E'' and hou.organization_id = paf.organization_id
810: and pps.period_of_service_id = paf.period_of_service_id