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

Line 283: from hr_assignment_set_amendments asgset,

279: elsif ln_asg_set is not null then
280:
281: lv_sql_string :=
282: 'select distinct paf.person_id
283: from hr_assignment_set_amendments asgset,
284: per_all_assignments_f paf
285: where assignment_set_id = ' || to_char(ln_asg_set) || '
286: and asgset.assignment_id = paf.assignment_id
287: and asgset.include_or_exclude = ''I''

Line 382: from hr_assignment_set_amendments asgset,

378: CURSOR c_selected_asg_set(cp_start_person in number
379: ,cp_end_person in number
380: ,cp_asg_set in number) is
381: select distinct paf.person_id
382: from hr_assignment_set_amendments asgset,
383: per_all_assignments_f paf,
384: pay_assignment_actions paa,
385: pay_payroll_actions ppa
386: where asgset.assignment_set_id = cp_asg_set

Line 407: from hr_assignment_set_amendments asgset,

403: CURSOR c_selected_asg_set_range(cp_start_person in number
404: ,cp_end_person in number
405: ,cp_asg_set in number) is
406: select distinct paf.person_id
407: from hr_assignment_set_amendments asgset,
408: per_all_assignments_f paf,
409: pay_assignment_actions paa,
410: pay_payroll_actions ppa,
411: pay_population_ranges ppr