2502: p_availability_status_id number) return varchar2 is
2503:
2504: cursor c_pos_shared_types is
2505: select system_type_cd
2506: from per_shared_types_vl
2507: where shared_type_id = p_availability_status_id;
2508:
2509: l_system_type_cd per_shared_types_vl.system_type_cd%TYPE := null;
2510:
2505: select system_type_cd
2506: from per_shared_types_vl
2507: where shared_type_id = p_availability_status_id;
2508:
2509: l_system_type_cd per_shared_types_vl.system_type_cd%TYPE := null;
2510:
2511: begin
2512: if p_availability_status_id is not null then
2513: open c_pos_shared_types;