DBA Data[Home] [Help]

APPS.PER_QH_FIND_QUERY dependencies on PER_BUSINESS_GROUPS

Line 6: ,business_group_name per_business_groups.name%type

2: /* $Header: peqhfndq.pkh 120.1 2005/12/29 05:34:28 rvarshne noship $ */
3:
4: type findrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_name per_business_groups.name%type
7: ,per_effective_start_date per_all_people_f.effective_start_date%type
8: ,per_effective_end_date per_all_people_f.effective_end_date%type
9: ,person_type varchar2(240)
10: ,system_person_type per_person_types.system_person_type%type

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

591:
592: procedure findquery(resultset IN OUT NOCOPY findtab
593: ,p_effective_date date
594: ,business_group_id per_all_people_f.business_group_id%type
595: ,business_group_name per_business_groups.name%type default null
596: ,person_id per_all_people_f.person_id%type default null
597: ,person_type per_person_types.user_person_type%type default null
598: ,system_person_type per_person_types.system_person_type%type default null
599: ,person_type_id per_all_people_f.person_type_id%type default null

Line 699: ,business_group_name in per_business_groups.name%type

695:
696: procedure findsave(
697: query_id in number
698: ,business_group_id in per_all_people_f.business_group_id%type
699: ,business_group_name in per_business_groups.name%type
700: ,person_id in per_all_people_f.person_id%type default null
701: ,person_type in per_person_types.user_person_type%type default null
702: ,system_person_type in per_person_types.system_person_type%type default null
703: ,person_type_id in per_all_people_f.person_type_id%type default null