APPS.HR_USER_ACCT_EMP_EXTRACT dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 119: FROM per_assignment_status_types ast

115: --
116: CURSOR lc_get_asg_status_type_id (p_per_sys_status in varchar2)
117: IS
118: SELECT ast.assignment_status_type_id
119: FROM per_assignment_status_types ast
120: WHERE nvl(ast.business_group_id, p_business_group_id)
121: = p_business_group_id
122: AND ast.active_flag = 'Y'
123: AND ast.per_system_status = p_per_sys_status;