APPS.HR_GENERAL2 dependencies on PER_ASSIGNMENT_STATUS_TYPES

Line 676: select distinct per_system_status from per_assignment_status_Types

672: ,p_show_current_flag in varchar2)
673: RETURN varchar2
674: is
675: cursor csr_status_types is
676: select distinct per_system_status from per_assignment_status_Types
677: where active_flag ='Y';
678: in_stmt varchar2(3000);
679: begin
680: in_stmt := '(''''';