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_ASGN_EVENTS dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 1372: ,per_assignment_status_types ast

1368: ,hpt.prsntyp_sk_pk prsntyp_sk_fk
1369: ,nvl(decode(hpt.include_flag_code,'Y',1,0),1) summarization_rqd_ind
1370: ,hpt.wkth_wktyp_code wkth_wktyp_code
1371: FROM per_all_assignments_f asg
1372: ,per_assignment_status_types ast
1373: ,per_periods_of_service pos
1374: ,per_periods_of_placement pop
1375: ,per_person_type_usages_f ptu
1376: ,hri_cs_prsntyp_ct hpt

Line 5161: ,per_assignment_status_types ast

5157: SELECT DISTINCT
5158: asg.assignment_id assignment_id,
5159: l_system_date change_date
5160: FROM per_all_assignments_f asg
5161: ,per_assignment_status_types ast
5162: WHERE asg.assignment_type in ('E','C')
5163: AND asg.assignment_id BETWEEN p_start_object_id and p_end_object_id
5164: AND ast.assignment_status_type_id = asg.assignment_status_type_id
5165: AND ast.per_system_status <> 'TERM_ASSIGN'