APPS.PQH_UTILITY dependencies on PER_SHARED_TYPES_TL

Line 21: from per_shared_types_tl stt,

17: p_shared_type_id IN Number,
18: p_business_group_id IN Number ) return varchar2 IS
19: Cursor csr_shd_type IS
20: select stt.shared_type_name
21: from per_shared_types_tl stt,
22: per_shared_types st
23: where stt.shared_type_id = st.shared_type_id
24: and stt.language = userenv('lang')
25: and st.shared_type_id = p_shared_type_id

Line 28: l_shared_type_name per_shared_types_tl.shared_type_name%TYPE;

24: and stt.language = userenv('lang')
25: and st.shared_type_id = p_shared_type_id
26: and (st.business_group_id = p_business_group_id or st.business_group_id is null );
27:
28: l_shared_type_name per_shared_types_tl.shared_type_name%TYPE;
29:
30: Begin
31:
32: If ( p_shared_type_id IS NULL OR p_business_group_id IS NULL) Then