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

Line 241: from per_all_assignments_f asg

237: if ln_person_id is not null then
238:
239: lv_sql_string :=
240: 'select distinct asg.person_id person_id
241: from per_all_assignments_f asg
242: where person_id = ' || to_char(ln_person_id) ||
243: ' and :p_payroll_action_id is not null';
244:
245: hr_utility.trace('Range for person_id not null');

Line 252: per_all_assignments_f paf

248:
249: lv_sql_string :=
250: 'select distinct paf.person_id
251: from hr_assignment_set_amendments asgset,
252: per_all_assignments_f paf
253: where assignment_set_id = ''' || ln_asg_set || '''
254: and asgset.assignment_id = paf.assignment_id
255: and asgset.include_or_exclude = ''I''
256: and :payroll_action_id is not null ';

Line 320: l_tmp_asg_id per_all_assignments_f.assignment_id%TYPE;

316: lv_full_name per_all_people_f.full_name%type;
317: lv_name varchar2(50);
318: lv_record_name varchar2(50);
319: --bug 6909112 starts here
320: l_tmp_asg_id per_all_assignments_f.assignment_id%TYPE;
321: --bug 6909112 ends here
322:
323:
324: CURSOR c_selected_asg_set(cp_start_person in number

Line 331: per_all_assignments_f paf

327: ,cp_eoy_pactid in number
328: ,cp_year_start_date in date) is
329: select distinct paf.person_id
330: from hr_assignment_set_amendments asgset,
331: per_all_assignments_f paf
332: where assignment_set_id = cp_asg_set
333: and asgset.include_or_exclude = 'I'
334: and paf.assignment_id = asgset.assignment_id
335: --and exists (select 1 from pay_assignment_actions paa