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_MMREF_REPORTING dependencies on PER_ALL_ASSIGNMENTS_F

Line 70: per_all_assignments_f

66: 02-Dec-2003 tmehra 115.16 Modified govt_mmrf_employee cursor.
67: 03-Dec-2003 tmehra 115.17 Modified govt_mmrf_employer cursor.
68: 28-DEC-2004 ahanda 115.19 Changed employee cursor for performance
69: 04-JAN-2004 ahanda 115.20 Changed per_assignments_f to
70: per_all_assignments_f
71: 18-NOV-2005 saurgupt 115.21 4644692 Added ORDERED hint in cursor mmrf_employee.
72: 04-AUG-2006 ppanda 115.22 Added following new function to support multithread architecture
73: in Federal W-2 Magnetic Media
74: - get_report_category_mt

Line 285: per_all_assignments_f SS,

281: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
282: FROM pay_payroll_actions PA,
283: pay_assignment_actions AA,
284: pay_action_interlocks AI,
285: per_all_assignments_f SS,
286: per_all_people_f PE
287: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
288: ('TRANSFER_PAYROLL_ACTION_ID')
289: AND AA.payroll_action_id = PA.payroll_action_id

Line 297: from per_all_assignments_f paf2

293: AND SS.assignment_id = AA.assignment_id
294: AND PE.person_id = SS.person_id
295: AND SS.effective_start_date =
296: (select max(paf2.effective_start_date)
297: from per_all_assignments_f paf2
298: where paf2.assignment_id = SS.assignment_id
299: and paf2.effective_start_date <= PA.effective_date
300: and paf2.assignment_type = 'E')
301: AND SS.effective_end_date >= PA.start_date

Line 316: per_all_assignments_f SS,

312: (PA.effective_date, AA.assignment_id)),
313: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
314: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
315: FROM per_all_people_f PE,
316: per_all_assignments_f SS,
317: pay_action_interlocks AI,
318: pay_assignment_actions AA,
319: pay_assignment_actions paa,
320: pay_payroll_actions PA,

Line 333: from per_all_assignments_f paf2

329: AND SS.assignment_id = AA.assignment_id
330: AND PE.person_id = SS.person_id
331: AND SS.effective_start_date =
332: (select max(paf2.effective_start_date)
333: from per_all_assignments_f paf2
334: where paf2.assignment_id = SS.assignment_id
335: and paf2.effective_start_date <= PA.effective_date
336: and paf2.assignment_type = 'E')
337: AND SS.effective_end_date >= PA.start_date

Line 364: per_all_assignments_f SS,

360: (PA.effective_date, AA.assignment_id)),
361: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
362: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
363: FROM per_all_people_f PE,
364: per_all_assignments_f SS,
365: pay_action_interlocks AI,
366: pay_assignment_actions AA,
367: pay_payroll_actions PA
368: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 378: from per_all_assignments_f paf2

374: AND SS.assignment_id = AA.assignment_id
375: AND PE.person_id = SS.person_id
376: AND SS.effective_start_date =
377: (select max(paf2.effective_start_date)
378: from per_all_assignments_f paf2
379: where paf2.assignment_id = SS.assignment_id
380: and paf2.effective_start_date <= PA.effective_date
381: and paf2.assignment_type = 'E')
382: AND SS.effective_end_date >= PA.start_date