APPS.PAY_CA_EOY_RL2_AMEND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 166: from per_all_assignments_f asg

162: if ln_person_id is not null then
163:
164: lv_sql_string :=
165: 'select distinct asg.person_id person_id
166: from per_all_assignments_f asg
167: where person_id = ' || to_char(ln_person_id) ||
168: ' and :p_payroll_action_id > 0';
169:
170: hr_utility.trace('Range for person_id not null');

Line 177: per_all_assignments_f paf

173:
174: lv_sql_string :=
175: 'select distinct paf.person_id
176: from hr_assignment_set_amendments asgset,
177: per_all_assignments_f paf
178: where assignment_set_id = ' || to_char(ln_asg_set) || '
179: and asgset.assignment_id = paf.assignment_id
180: and asgset.include_or_exclude = ''I''
181: and :payroll_action_id > 0

Line 199: from per_all_assignments_f asg

195: pay_core_utils.push_token('description',substr(lv_message,1,50));
196:
197: lv_sql_string :=
198: 'select distinct asg.person_id person_id
199: from per_all_assignments_f asg
200: where person_id = 0
201: and :p_payroll_action_id > 0
202: order by asg.person_id ';
203:

Line 270: per_all_assignments_f paf,

266: ,cp_end_person in number
267: ,cp_asg_set in number) is
268: select distinct paf.person_id
269: from hr_assignment_set_amendments asgset,
270: per_all_assignments_f paf,
271: pay_assignment_actions paa,
272: pay_payroll_actions ppa
273: where asgset.assignment_set_id = cp_asg_set
274: and asgset.include_or_exclude = 'I'