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

Line 274: per_all_assignments_f SS,

270: (PA.effective_date, AA.assignment_id)),
271: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
272: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
273: FROM per_all_people_f PE,
274: per_all_assignments_f SS,
275: pay_action_interlocks AI,
276: pay_assignment_actions AA,
277: pay_payroll_actions PA
278: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 287: from per_all_assignments_f paf2

283: AND AI.locking_action_id = AA.assignment_action_id
284: AND SS.assignment_id = AA.assignment_id
285: AND PE.person_id = SS.person_id
286: AND SS.effective_start_date = (select max(paf2.effective_start_date)
287: from per_all_assignments_f paf2
288: where paf2.assignment_id = SS.assignment_id
289: and paf2.effective_start_date <= PA.effective_date
290: and paf2.assignment_type = 'E')
291: AND SS.effective_end_date >= PA.start_date

Line 306: per_all_assignments_f SS,

302: (PA.effective_date, AA.assignment_id)),
303: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
304: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
305: FROM per_all_people_f PE,
306: per_all_assignments_f SS,
307: pay_action_interlocks AI,
308: pay_assignment_actions AA,
309: pay_assignment_actions paa,
310: pay_payroll_actions PA,

Line 323: from per_all_assignments_f paf2

319: AND SS.assignment_id = AA.assignment_id
320: AND PE.person_id = SS.person_id
321: AND SS.effective_start_date =
322: (select max(paf2.effective_start_date)
323: from per_all_assignments_f paf2
324: where paf2.assignment_id = SS.assignment_id
325: and paf2.effective_start_date <= PA.effective_date
326: and paf2.assignment_type = 'E')
327: AND SS.effective_end_date >= PA.start_date

Line 354: per_all_assignments_f SS,

350: (PA.effective_date, AA.assignment_id)),
351: 'JURISDICTION_CODE=C',pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
352: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id
353: FROM per_all_people_f PE,
354: per_all_assignments_f SS,
355: pay_action_interlocks AI,
356: pay_assignment_actions AA,
357: pay_payroll_actions PA
358: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 368: from per_all_assignments_f paf2

364: AND SS.assignment_id = AA.assignment_id
365: AND PE.person_id = SS.person_id
366: AND SS.effective_start_date =
367: (select max(paf2.effective_start_date)
368: from per_all_assignments_f paf2
369: where paf2.assignment_id = SS.assignment_id
370: and paf2.effective_start_date <= PA.effective_date
371: and paf2.assignment_type = 'E')
372: AND SS.effective_end_date >= PA.start_date

Line 443: per_all_assignments_f SS,

439: 'JURISDICTION_CODE=C', pay_magtape_generic.get_parameter_value('TRANSFER_JD'),
440: 'YE_ASSIGNMENT_ACTION_ID=P',AI.locked_action_id,
441: 'TAX_UNIT_ID=C',AA.TAX_UNIT_ID
442: FROM per_all_people_f PE,
443: per_all_assignments_f SS,
444: pay_action_interlocks AI,
445: pay_assignment_actions AA,
446: pay_payroll_actions PA
447: WHERE PA.payroll_action_id = pay_magtape_generic.get_parameter_value

Line 455: from per_all_assignments_f paf2

451: AND AI.locking_action_id = AA.assignment_action_id
452: AND SS.assignment_id = AA.assignment_id
453: AND PE.person_id = SS.person_id
454: AND SS.effective_start_date = (select max(paf2.effective_start_date)
455: from per_all_assignments_f paf2
456: where paf2.assignment_id = SS.assignment_id
457: and paf2.effective_start_date <= PA.effective_date
458: and paf2.assignment_type = 'E')
459: AND SS.effective_end_date >= PA.start_date