APPS.PAY_CA_EOY_RL2_AMEND_REG dependencies on PER_ASSIGNMENTS_F

Line 166: from per_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_assignments_f asg
167: where person_id = ' || ln_person_id ||
168: ' and :payroll_action_id > 0';
169:
170: hr_utility.trace('Range for person_id not null');

Line 177: per_assignments_f paf

173:
174: lv_sql_string :=
175: 'select distinct paf.person_id
176: from hr_assignment_set_amendments asgset,
177: per_assignments_f paf
178: where assignment_set_id = ' || 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 192: per_assignments_f paf,

188: lv_sql_string :=
189: 'select distinct paf.person_id
190: from pay_payroll_actions ppa_arch,
191: pay_assignment_actions paa_arch,
192: per_assignments_f paf,
193: pay_payroll_actions ppa
194: where paa_arch.assignment_id = paf.assignment_id
195: and ppa.payroll_action_id = :payroll_action_id
196: and ppa_arch.business_group_id = ppa.business_group_id

Line 211: per_assignments_f paf,

207: lv_sql_string :=
208: 'select distinct paf.person_id
209: from pay_payroll_actions ppa_arch,
210: pay_assignment_actions paa_arch,
211: per_assignments_f paf,
212: pay_payroll_actions ppa
213: where paa_arch.assignment_id = paf.assignment_id
214: and ppa.payroll_action_id = :payroll_action_id
215: and ppa_arch.business_group_id = ppa.business_group_id

Line 282: per_assignments_f paf,

278: ,cp_asg_set in number
279: ,cp_effective_date in date) is
280: select distinct paf.person_id
281: from hr_assignment_set_amendments asgset,
282: per_assignments_f paf,
283: pay_payroll_actions ppa_arch,
284: pay_assignment_actions paa_arch
285: where asgset.assignment_set_id = cp_asg_set
286: and asgset.include_or_exclude = 'I'

Line 376: from per_assignments_f paf

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

Line 404: from per_assignments_f paf

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