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 295: per_all_assignments_f SS,

291: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
292: FROM pay_payroll_actions PA,
293: pay_assignment_actions AA,
294: pay_action_interlocks AI,
295: per_all_assignments_f SS,
296: per_all_people_f PE
297: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value
298: ('TRANSFER_PAYROLL_ACTION_ID')
299: AND AA.payroll_action_id = PA.payroll_action_id

Line 307: from per_all_assignments_f paf2

303: AND SS.assignment_id = AA.assignment_id
304: AND PE.person_id = SS.person_id
305: AND SS.effective_start_date =
306: (select max(paf2.effective_start_date)
307: from per_all_assignments_f paf2
308: where paf2.assignment_id = SS.assignment_id
309: and paf2.effective_start_date <= PA.effective_date
310: and paf2.assignment_type = 'E')
311: AND SS.effective_end_date >= PA.start_date

Line 326: per_all_assignments_f SS,

322: (PA.effective_date, AA.assignment_id)),
323: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
324: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
325: FROM per_all_people_f PE,
326: per_all_assignments_f SS,
327: pay_action_interlocks AI,
328: pay_assignment_actions AA,
329: pay_assignment_actions paa,
330: pay_payroll_actions PA,

Line 343: from per_all_assignments_f paf2

339: AND SS.assignment_id = AA.assignment_id
340: AND PE.person_id = SS.person_id
341: AND SS.effective_start_date =
342: (select max(paf2.effective_start_date)
343: from per_all_assignments_f paf2
344: where paf2.assignment_id = SS.assignment_id
345: and paf2.effective_start_date <= PA.effective_date
346: and paf2.assignment_type = 'E')
347: AND SS.effective_end_date >= PA.start_date

Line 374: per_all_assignments_f SS,

370: (PA.effective_date, AA.assignment_id)),
371: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
372: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
373: FROM per_all_people_f PE,
374: per_all_assignments_f SS,
375: pay_action_interlocks AI,
376: pay_assignment_actions AA,
377: pay_payroll_actions PA
378: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 388: from per_all_assignments_f paf2

384: AND SS.assignment_id = AA.assignment_id
385: AND PE.person_id = SS.person_id
386: AND SS.effective_start_date =
387: (select max(paf2.effective_start_date)
388: from per_all_assignments_f paf2
389: where paf2.assignment_id = SS.assignment_id
390: and paf2.effective_start_date <= PA.effective_date
391: and paf2.assignment_type = 'E')
392: AND SS.effective_end_date >= PA.start_date