eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_CA_RL1_REG dependencies on PER_ASSIGNMENTS_F

Line 287: per_assignments_f paf

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
291: and paf.person_id = ppf.person_id

Line 305: per_assignments_f paf

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
309: and paf.person_id = ppf.person_id

Line 326: per_assignments_f paf

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
330: and paf.person_id = ppf.person_id

Line 344: from per_assignments_f paf

340: order by 1,2;
341:
342: cursor c_get_asg_id (p_person_id number) is
343: select assignment_id
344: from per_assignments_f paf
345: where person_id = p_person_id
346: and primary_flag = 'Y'
347: and assignment_type = 'E'
348: and paf.effective_start_date <= l_year_end