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.HRFASTANSWERS dependencies on PER_ALL_ASSIGNMENTS_F

Line 505: , per_all_assignments_f asg

501: , asg.effective_start_date
502: , asg.effective_end_date
503: , asg.organization_id
504: from per_assignment_status_types ast
505: , per_all_assignments_f asg
506: where asg.assignment_status_type_id = ast.assignment_status_type_id
507: and asg.assignment_id = p_assignment_id
508: and asg.effective_start_date <= p_period_end_date
509: order by asg.effective_start_date desc;

Line 514: , per_all_assignments_f asg

510: --
511: cursor hire_date_csr is
512: select per.start_date
513: from per_all_people_f per
514: , per_all_assignments_f asg
515: where asg.person_id = per.person_id
516: and p_period_end_date between per.effective_start_date and per.effective_end_date
517: and p_period_end_date between asg.effective_start_date and asg.effective_end_date
518: and asg.assignment_id = p_assignment_id;

Line 534: , per_all_assignments_f asg

530: 3, '3-5 Years',
531: 4, '3-5 Years',
532: '5 Years+')) service_band
533: from per_periods_of_service pos
534: , per_all_assignments_f asg
535: where asg.period_of_service_id = pos.period_of_service_id
536: and p_period_start_date-1 between asg.effective_start_date and asg.effective_end_date
537: and asg.assignment_id = p_assignment_id;
538: --