APPS.PAY_US_W2C_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 244: from per_all_assignments_f asg

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

Line 255: per_all_assignments_f paf

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

Line 323: l_tmp_asg_id per_all_assignments_f.assignment_id%TYPE;

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

Line 334: per_all_assignments_f paf

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