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

Line 279: from hr_assignment_set_amendments asgset,

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

Line 378: from hr_assignment_set_amendments asgset,

374: CURSOR c_selected_asg_set(cp_start_person in number
375: ,cp_end_person in number
376: ,cp_asg_set in number) is
377: select distinct paf.person_id
378: from hr_assignment_set_amendments asgset,
379: per_all_assignments_f paf,
380: pay_assignment_actions paa,
381: pay_payroll_actions ppa
382: where

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