APPS.PAY_CA_EOY_T4A_AMEND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 273: from per_all_assignments_f asg

269: if ln_person_id is not null then
270:
271: lv_sql_string :=
272: 'select distinct asg.person_id person_id
273: from per_all_assignments_f asg
274: where person_id = ' || to_char(ln_person_id) ||
275: ' and :p_payroll_action_id > 0';
276:
277: hr_utility.trace('Range for person_id not null');

Line 284: per_all_assignments_f paf

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''
288: and :payroll_action_id > 0

Line 306: from per_all_assignments_f asg

302: pay_core_utils.push_token('description',substr(lv_message,1,50));
303:
304: lv_sql_string :=
305: 'select distinct asg.person_id person_id
306: from per_all_assignments_f asg
307: where person_id = 0
308: and :p_payroll_action_id > 0
309: order by asg.person_id ';
310:

Line 383: per_all_assignments_f paf,

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
387: and asgset.include_or_exclude = 'I'

Line 408: per_all_assignments_f paf,

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
412: where asgset.assignment_set_id = cp_asg_set