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.PER_DB_PER_ADDITIONAL dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 913: FROM per_assignment_status_types ast

909: AND default_flag = 'Y'
910: AND per_system_status = 'ACTIVE_APL'
911: UNION
912: SELECT ast.assignment_status_type_id
913: FROM per_assignment_status_types ast
914: WHERE nvl(ast.business_group_id,l_business_group_id)
915: = l_business_group_id
916: AND ast.default_flag = 'Y'
917: AND ast.per_system_status = 'ACTIVE_APL'

Line 1310: FROM per_assignment_status_types ast

1306: AND default_flag = 'Y'
1307: AND per_system_status = 'ACTIVE_ASSIGN'
1308: UNION
1309: SELECT ast.assignment_status_type_id
1310: FROM per_assignment_status_types ast
1311: WHERE nvl(ast.business_group_id,l_business_group_id)
1312: = l_business_group_id
1313: AND ast.default_flag = 'Y'
1314: AND ast.per_system_status = 'ACTIVE_ASSIGN'

Line 1767: FROM per_assignment_status_types ast

1763: AND default_flag = 'Y'
1764: AND per_system_status = 'ACTIVE_ASSIGN'
1765: UNION
1766: SELECT ast.assignment_status_type_id
1767: FROM per_assignment_status_types ast
1768: WHERE nvl(ast.business_group_id,l_business_group_id)
1769: = l_business_group_id
1770: AND ast.default_flag = 'Y'
1771: AND ast.per_system_status = 'ACTIVE_ASSIGN'

Line 1789: FROM per_assignment_status_types ast

1785: AND default_flag = 'Y'
1786: AND per_system_status = 'ACTIVE_APL'
1787: UNION
1788: SELECT ast.assignment_status_type_id
1789: FROM per_assignment_status_types ast
1790: WHERE nvl(ast.business_group_id,l_business_group_id)
1791: = l_business_group_id
1792: AND ast.default_flag = 'Y'
1793: AND ast.per_system_status = 'ACTIVE_APL'