APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 278: from per_all_assignments_f asg

274: if ln_person_id is not null then
275:
276: lv_sql_string :=
277: 'select distinct asg.person_id person_id
278: from per_all_assignments_f asg
279: where person_id = ' || to_char(ln_person_id) ||
280: ' and :p_payroll_action_id > 0';
281:
282: hr_utility.trace('Range for person_id not null');

Line 289: per_all_assignments_f paf

285:
286: lv_sql_string :=
287: 'select distinct paf.person_id
288: from hr_assignment_set_amendments asgset,
289: per_all_assignments_f paf
290: where assignment_set_id = ' || to_char(ln_asg_set) || '
291: and asgset.assignment_id = paf.assignment_id
292: and asgset.include_or_exclude = ''I''
293: and :payroll_action_id > 0

Line 311: from per_all_assignments_f asg

307: pay_core_utils.push_token('description',substr(lv_message,1,50));
308:
309: lv_sql_string :=
310: 'select distinct asg.person_id person_id
311: from per_all_assignments_f asg
312: where person_id = 0
313: and :p_payroll_action_id > 0
314: order by asg.person_id ';
315:

Line 388: per_all_assignments_f paf,

384: ,cp_end_person in number
385: ,cp_asg_set in number) is
386: select distinct paf.person_id
387: from hr_assignment_set_amendments asgset,
388: per_all_assignments_f paf,
389: pay_assignment_actions paa,
390: pay_payroll_actions ppa
391: where
392: (pay_ca_eoy_rl1_amend_arch.get_parameter('PRE_ORGANIZATION_ID',

Line 419: per_all_assignments_f paf,

415: ,cp_end_person in number
416: ,cp_asg_set in number) is
417: select distinct paf.person_id
418: from hr_assignment_set_amendments asgset,
419: per_all_assignments_f paf,
420: pay_assignment_actions paa,
421: pay_payroll_actions ppa,
422: pay_population_ranges ppr
423: where