APPS.PQH_UTILITY dependencies on PER_SHARED_TYPES

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 22: per_shared_types st

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
26: and (st.business_group_id = p_business_group_id or st.business_group_id is null );

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

Line 1158: from per_shared_types_vl

1154:
1155:
1156: function get_unit_desc(p_unit_id in number) return varchar2 is
1157: cursor c1 is select shared_type_name
1158: from per_shared_types_vl
1159: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
1160: and shared_type_id = p_unit_id;
1161: l_shared_type_name per_shared_types_vl.shared_type_name%type;
1162: begin

Line 1161: l_shared_type_name per_shared_types_vl.shared_type_name%type;

1157: cursor c1 is select shared_type_name
1158: from per_shared_types_vl
1159: where lookup_type ='BUDGET_MEASUREMENT_TYPE'
1160: and shared_type_id = p_unit_id;
1161: l_shared_type_name per_shared_types_vl.shared_type_name%type;
1162: begin
1163: open c1;
1164: fetch c1 into l_shared_type_name;
1165: close c1;