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

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

Line 286: from per_all_assignments_f paf2

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

Line 305: per_all_assignments_f SS,

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

Line 322: from per_all_assignments_f paf2

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

Line 353: per_all_assignments_f SS,

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

Line 367: from per_all_assignments_f paf2

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

Line 442: per_all_assignments_f SS,

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

Line 454: from per_all_assignments_f paf2

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