APPS.PAY_CA_EOY_T4A_AMEND_REG dependencies on PER_ASSIGNMENTS_F

Line 180: from per_assignments_f asg

176: if ln_person_id is not null then
177:
178: lv_sql_string :=
179: 'select distinct asg.person_id person_id
180: from per_assignments_f asg
181: where person_id = ' || ln_person_id ||
182: ' and :p_payroll_action_id > 0';
183:
184: hr_utility.trace('Range for person_id not null');

Line 191: per_assignments_f paf

187:
188: lv_sql_string :=
189: 'select distinct paf.person_id
190: from hr_assignment_set_amendments asgset,
191: per_assignments_f paf
192: where assignment_set_id = ' || ln_asg_set || '
193: and asgset.assignment_id = paf.assignment_id
194: and asgset.include_or_exclude = ''I''
195: and :p_payroll_action_id > 0

Line 206: per_assignments_f paf,

202: lv_sql_string :=
203: 'select distinct paf.person_id
204: from pay_payroll_actions ppa_arch,
205: pay_assignment_actions paa_arch,
206: per_assignments_f paf,
207: pay_payroll_actions ppa
208: where paa_arch.assignment_id = paf.assignment_id
209: and ppa.payroll_action_id = :p_payroll_action_id
210: and ppa_arch.business_group_id = ppa.business_group_id

Line 224: per_assignments_f paf,

220: lv_sql_string :=
221: 'select distinct paf.person_id
222: from pay_payroll_actions ppa_arch,
223: pay_assignment_actions paa_arch,
224: per_assignments_f paf,
225: pay_payroll_actions ppa
226: where paa_arch.assignment_id = paf.assignment_id
227: and ppa.payroll_action_id = :p_payroll_action_id
228: and ppa_arch.business_group_id = ppa.business_group_id

Line 297: per_assignments_f paf,

293: ,cp_asg_set in number
294: ,cp_effective_date in date) is
295: select distinct paf.person_id
296: from hr_assignment_set_amendments asgset,
297: per_assignments_f paf,
298: pay_payroll_actions ppa,
299: pay_assignment_actions paa
300: where asgset.assignment_set_id = cp_asg_set
301: and asgset.include_or_exclude = 'I'

Line 380: from per_assignments_f paf

376: and not exists (select 1
377: from pay_action_interlocks
378: where locked_action_id = paa.assignment_action_id)
379: and exists (select 1
380: from per_assignments_f paf
381: where paf.assignment_id = paa.assignment_id
382: and paf.effective_start_date <= cp_effective_date
383: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
384: order by paa.assignment_action_id desc;

Line 403: from per_assignments_f paf

399: and ppa.payroll_action_id = paa.payroll_action_id
400: and ppa.effective_date = cp_effective_date
401: and ppa.report_type = 'CAEOY_T4A_AMEND_PP'
402: and exists (select 1
403: from per_assignments_f paf
404: where paf.assignment_id = paa.assignment_id
405: and paf.effective_start_date <= cp_effective_date
406: and paf.effective_end_date >= trunc(cp_effective_date,'Y'))
407: order by paa.assignment_action_id desc;