APPS.PAY_CA_EOY_T4_AMEND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 46: per_all_assignments_f.

42: has been specified.
43: 01-SEP-2004 SSouresr 115.4 Cleaned up the package by taking out
44: some unnecessary code and a
45: redundant join on
46: per_all_assignments_f.
47: 01-SEP-2004 SSattini 115.5 Fixed the GSCC errors.
48: 15-NOV-2004 SSouresr 115.6 Replaced per_people_f with per_all_people_f
49: 07-MAR-2005 SSouresr 115.7 Removed extra p_payroll_action_id from
50: the range cursor

Line 186: from per_all_assignments_f asg

182: if ln_person_id is not null then
183:
184: lv_sql_string :=
185: 'select distinct asg.person_id person_id
186: from per_all_assignments_f asg
187: where person_id = ' || to_char(ln_person_id) ||
188: ' and :p_payroll_action_id > 0';
189:
190: hr_utility.trace('Range for person_id not null');

Line 197: per_all_assignments_f paf

193:
194: lv_sql_string :=
195: 'select distinct paf.person_id
196: from hr_assignment_set_amendments asgset,
197: per_all_assignments_f paf
198: where assignment_set_id = ' || to_char(ln_asg_set) || '
199: and asgset.assignment_id = paf.assignment_id
200: and asgset.include_or_exclude = ''I''
201: and :payroll_action_id > 0

Line 219: from per_all_assignments_f asg

215: pay_core_utils.push_token('description',substr(lv_message,1,50));
216:
217: lv_sql_string :=
218: 'select distinct asg.person_id person_id
219: from per_all_assignments_f asg
220: where person_id = 0
221: and :p_payroll_action_id > 0
222: order by asg.person_id';
223:

Line 290: per_all_assignments_f paf,

286: ,cp_end_person in number
287: ,cp_asg_set in number) is
288: select distinct paf.person_id
289: from hr_assignment_set_amendments asgset,
290: per_all_assignments_f paf,
291: pay_assignment_actions paa,
292: pay_payroll_actions ppa
293: where asgset.assignment_set_id = cp_asg_set
294: and asgset.include_or_exclude = 'I'