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.HRI_OPL_WMV dependencies on PER_PERIODS_OF_SERVICE

Line 940: ,per_periods_of_service pos

936: FROM
937: per_assignment_budget_values_f abv
938: ,per_all_assignments_f asg
939: ,per_assignment_status_types ast
940: ,per_periods_of_service pos
941: WHERE abv.assignment_id = asg.assignment_id
942: AND asg.assignment_id = p_assignment_id
943: AND asg.period_of_service_id = pos.period_of_service_id
944: AND ast.assignment_status_type_id = asg.assignment_status_type_id

Line 990: ,per_periods_of_service pos

986: FROM
987: per_assignment_budget_values_f abv
988: ,per_all_assignments_f asg
989: ,per_assignment_status_types ast
990: ,per_periods_of_service pos
991: WHERE abv.assignment_id = asg.assignment_id
992: AND asg.assignment_id = p_assignment_id
993: AND pos.period_of_service_id = asg.period_of_service_id
994: AND asg.assignment_type = 'E'

Line 1028: ,per_periods_of_service pos

1024: ,pos.final_process_date final_process_date
1025: FROM
1026: per_all_assignments_f asg
1027: ,per_assignment_status_types ast
1028: ,per_periods_of_service pos
1029: WHERE asg.assignment_id = p_assignment_id
1030: AND pos.period_of_service_id = asg.period_of_service_id
1031: AND ast.assignment_status_type_id = asg.assignment_status_type_id
1032: AND asg.assignment_type = 'E'

Line 1066: ,per_periods_of_service pos

1062: per_assignment_budget_values_f abv
1063: ,per_all_assignments_f asg
1064: ,per_all_assignments_f next_asg
1065: ,per_assignment_status_types ast
1066: ,per_periods_of_service pos
1067: WHERE abv.assignment_id = asg.assignment_id
1068: AND asg.assignment_id = p_assignment_id
1069: AND next_asg.assignment_id = asg.assignment_id
1070: AND next_asg.effective_start_date = asg.effective_end_date + 1

Line 1452: ,per_periods_of_service pos

1448: ,asg.last_update_date last_change_date
1449: FROM
1450: per_all_assignments_f asg
1451: ,per_assignment_status_types ast
1452: ,per_periods_of_service pos
1453: WHERE pos.period_of_service_id = asg.period_of_service_id
1454: AND ast.assignment_status_type_id = asg.assignment_status_type_id
1455: AND asg.assignment_type = 'E'
1456: AND trunc(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date;