APPS.PAY_CA_RL2_REG dependencies on PER_ASSIGNMENTS_F

Line 169: from per_assignments_f paf

165: and paa.assignment_id = cp_assignment_id;
166:
167: cursor c_get_asg_id (p_person_id number) is
168: select assignment_id
169: from per_assignments_f paf
170: where person_id = p_person_id
171: and primary_flag = 'Y'
172: and assignment_type = 'E'
173: and paf.effective_start_date <= l_year_end

Line 209: per_assignments_f paf

205: /*
206: select distinct paf.assignment_id assignment_id,
207: paf.person_id person_id
208: from
209: per_assignments_f paf
210: where paf.person_id between stperson and endperson
211: and paf.assignment_type = 'E'
212: and paf.primary_flag = 'Y'
213: and paf.effective_end_date >= l_year_start

Line 217: from per_assignments_f paf2

213: and paf.effective_end_date >= l_year_start
214: and paf.business_group_id = l_bus_group_id
215: and paf.effective_start_date =
216: (select max(paf2.effective_start_date)
217: from per_assignments_f paf2
218: where paf2.assignment_id = paf.assignment_id
219: and paf2.effective_start_date <= l_year_end )
220:
221: order by paf.person_id;

Line 246: per_assignments_f paf

242: /*
243: select distinct paf.assignment_id assignment_id,
244: paf.person_id person_id
245: from
246: per_assignments_f paf
247: where paf.person_id between stperson and endperson
248: and paf.person_id = to_number(l_per_id)
249: and paf.assignment_type = 'E'
250: and paf.primary_flag = 'Y'

Line 276: per_assignments_f paf

272: and ppa.payroll_action_id = paa.payroll_action_id
273: and to_number(paa.serial_number) between stperson and endperson
274: and exists (select 1
275: from hr_assignment_set_amendments hasa,
276: per_assignments_f paf
277: where hasa.assignment_set_id = l_asg_set_id
278: and upper(hasa.include_or_exclude) = 'I'
279: and hasa.assignment_id = paf.assignment_id
280: and paf.person_id = to_number(paa.serial_number));

Line 285: from per_assignments_f paf

281:
282: /*
283: select distinct paf.assignment_id assignment_id,
284: paf.person_id person_id
285: from per_assignments_f paf
286: where paf.person_id between stperson and endperson
287: and paf.assignment_type = 'E'
288: and paf.primary_flag = 'Y'
289: and paf.effective_start_date <= l_year_end