APPS.PAY_CA_EOY_RL1_AMEND_ARCH dependencies on PER_ALL_ASSIGNMENTS_F

Line 176: from per_all_assignments_f asg

172: if ln_person_id is not null then
173:
174: lv_sql_string :=
175: 'select distinct asg.person_id person_id
176: from per_all_assignments_f asg
177: where person_id = ' || to_char(ln_person_id) ||
178: ' and :p_payroll_action_id > 0';
179:
180: hr_utility.trace('Range for person_id not null');

Line 187: per_all_assignments_f paf

183:
184: lv_sql_string :=
185: 'select distinct paf.person_id
186: from hr_assignment_set_amendments asgset,
187: per_all_assignments_f paf
188: where assignment_set_id = ' || to_char(ln_asg_set) || '
189: and asgset.assignment_id = paf.assignment_id
190: and asgset.include_or_exclude = ''I''
191: and :payroll_action_id > 0

Line 209: from per_all_assignments_f asg

205: pay_core_utils.push_token('description',substr(lv_message,1,50));
206:
207: lv_sql_string :=
208: 'select distinct asg.person_id person_id
209: from per_all_assignments_f asg
210: where person_id = 0
211: and :p_payroll_action_id > 0
212: order by asg.person_id ';
213:

Line 280: per_all_assignments_f paf,

276: ,cp_end_person in number
277: ,cp_asg_set in number) is
278: select distinct paf.person_id
279: from hr_assignment_set_amendments asgset,
280: per_all_assignments_f paf,
281: pay_assignment_actions paa,
282: pay_payroll_actions ppa
283: where asgset.assignment_set_id = cp_asg_set
284: and asgset.include_or_exclude = 'I'