DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_QUERY dependencies on PER_BUSINESS_GROUPS

Line 7: ,business_group_name per_business_groups.name%type

3:
4: type mainrec is RECORD
5: (person_id per_all_people_f.person_id%type
6: ,business_group_id per_all_people_f.business_group_id%type
7: ,business_group_name per_business_groups.name%type
8: ,per_effective_start_date per_all_people_f.effective_start_date%type
9: ,per_effective_end_date per_all_people_f.effective_end_date%type
10: ,per_validation_start_date date
11: ,per_validation_end_date date

Line 19: ,legislation per_business_groups.legislation_code%type

15: ,last_name per_all_people_f.last_name%type
16: ,start_date per_all_people_f.start_date%type
17: ,applicant_number per_all_people_f.applicant_number%type
18: --added below for PMxBG
19: ,legislation per_business_groups.legislation_code%type
20: ,background_check_status per_all_people_f.background_check_status%type
21: ,background_date_check per_all_people_f.background_date_check%type
22: ,blood_type_meaning hr_lookups.meaning%type
23: ,blood_type per_all_people_f.blood_type%type