APPS.PER_QH_FIND_QUERY dependencies on PER_BUSINESS_GROUPS

Line 13: ,business_group_name per_business_groups.name%type default null

9:
10: procedure findquery(resultset IN OUT NOCOPY findtab
11: ,p_effective_date date
12: ,business_group_id per_all_people_f.business_group_id%type
13: ,business_group_name per_business_groups.name%type default null
14: ,person_id per_all_people_f.person_id%type default null
15: ,person_type per_person_types.user_person_type%type default null
16: ,system_person_type per_person_types.system_person_type%type default null
17: ,person_type_id per_all_people_f.person_type_id%type default null

Line 142: from per_business_groups x

138: --Modified for PMxbg
139: cursor csr_bg_name
140: (p_business_group_id number) is
141: select x.name
142: from per_business_groups x
143: where x.business_group_id = p_business_group_id;
144: --
145: cursor csr_person_details
146: (p_person_id number

Line 811: l_from_clause:=l_from_clause||',per_business_groups b';

807: --Modified for PMxbg
808:
809: --commmented for PMP
810: -- if business_group_name is not null then
811: l_from_clause:=l_from_clause||',per_business_groups b';
812: l_where_clause:=l_where_clause||' and per.business_group_id=b.business_group_id'
813: ||' and (upper(b.name) like ('''||upper(replace(business_group_name,g_quote,g_quote||g_quote))||''') or '''
814: ||(replace(business_group_name,g_quote,g_quote||g_quote))||''' is null)'; --fix for bug 8648029
815: --commmented for PMP

Line 2455: ,business_group_name in per_business_groups.name%type

2451: --
2452: procedure findsave(
2453: query_id in number
2454: ,business_group_id in per_all_people_f.business_group_id%type
2455: ,business_group_name in per_business_groups.name%type
2456: ,person_id in per_all_people_f.person_id%type default null
2457: ,person_type in per_person_types.user_person_type%type default null
2458: ,system_person_type in per_person_types.system_person_type%type default null
2459: ,person_type_id in per_all_people_f.person_type_id%type default null