DBA Data[Home] [Help]

APPS.PAY_CA_RL1_REG dependencies on PER_PEOPLE_F

Line 286: from per_people_f ppf,

282: , l_year_start date
283: , l_year_end date ) is
284: select distinct paf.person_id,
285: paf.assignment_id assignment_id
286: from per_people_f ppf,
287: per_assignments_f paf
288: where ppf.person_id between stperson and endperson
289: and ppf.effective_start_date <= l_year_end
290: and ppf.effective_end_date >= l_year_start

Line 304: from per_people_f ppf,

300: ,l_year_end date
301: ,l_per_id varchar2) is
302: select distinct paf.person_id,
303: paf.assignment_id assignment_id
304: from per_people_f ppf,
305: per_assignments_f paf
306: where ppf.person_id between stperson and endperson
307: and ppf.effective_start_date <= l_year_end
308: and ppf.effective_end_date >= l_year_start

Line 325: from per_people_f ppf,

321: ,l_year_start date
322: ,l_year_end date ) is
323: select distinct paf.person_id,
324: paf.assignment_id assignment_id
325: from per_people_f ppf,
326: per_assignments_f paf
327: where ppf.person_id between stperson and endperson
328: and ppf.effective_start_date <= l_year_end
329: and ppf.effective_end_date >= l_year_start