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_AU_PAYMENT_SUMMARY_AMEND dependencies on HR_ASSIGNMENT_SET_AMENDMENTS

Line 356: ,hr_assignment_set_amendments has

352: SELECT DISTINCT paf.assignment_id
353: FROM per_assignments_f paf
354: ,per_people_f ppf
355: ,pay_payroll_actions ppa
356: ,hr_assignment_set_amendments has
357: WHERE ppa.payroll_action_id = c_payroll_action_id
358: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
359: AND ppf.person_id = paf.person_id
360: AND paf.assignment_id = has.assignment_id

Line 405: ,hr_assignment_set_amendments has

401: SELECT DISTINCT paf.assignment_id
402: FROM per_assignments_f paf
403: ,per_people_f ppf
404: ,pay_payroll_actions ppa
405: ,hr_assignment_set_amendments has
406: WHERE ppa.payroll_action_id = c_payroll_action_id
407: AND ppf.person_id BETWEEN c_start_person_id AND c_end_person_id
408: AND ppf.person_id = paf.person_id
409: AND paf.assignment_id = has.assignment_id

Line 446: hr_assignment_set_amendments has

442: paf.assignment_id
443: FROM pay_payroll_actions ppa,
444: pay_population_ranges ppr,
445: per_assignments_f paf,
446: hr_assignment_set_amendments has
447: WHERE ppa.payroll_action_id = c_payroll_action_id
448: AND ppr.payroll_action_id = ppa.payroll_action_id
449: AND ppr.chunk_number = c_chunk
450: AND paf.person_id = ppr.person_id

Line 513: hr_assignment_set_amendments has

509: paf.assignment_id
510: FROM pay_payroll_actions ppa,
511: pay_population_ranges ppr,
512: per_assignments_f paf,
513: hr_assignment_set_amendments has
514: WHERE ppa.payroll_action_id = c_payroll_action_id
515: AND ppr.payroll_action_id = ppa.payroll_action_id
516: AND ppr.chunk_number = c_chunk
517: AND paf.person_id = ppr.person_id