APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 269: from per_all_assignments_f asg

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

Line 280: per_all_assignments_f paf

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

Line 302: from per_all_assignments_f asg

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

Line 379: per_all_assignments_f paf,

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
383: (pay_ca_eoy_rl2_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

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