DBA Data[Home] [Help]

APPS.PER_DB_PER_ADDITIONAL dependencies on PER_PERSON_TYPES

Line 899: FROM per_person_types

895: hr_utility.set_location('per_db_per_additional.create_applicant',2);
896: --
897: SELECT person_type_id
898: INTO l_person_type_id
899: FROM per_person_types
900: WHERE business_group_id = l_business_group_id --Bug fix 3648477
901: AND system_person_type = 'APL'
902: AND default_flag = 'Y';
903: --

Line 1296: FROM per_person_types

1292: hr_utility.set_location('per_db_per_additional.create_employee',2);
1293: --
1294: SELECT person_type_id
1295: INTO l_person_type_id
1296: FROM per_person_types
1297: WHERE business_group_id = l_business_group_id --Bug fix 3648477
1298: AND system_person_type = 'EMP'
1299: AND default_flag = 'Y';
1300: --

Line 1611: FROM per_person_types

1607: hr_utility.set_location('per_db_per_additional.create_other',2);
1608: --
1609: SELECT person_type_id
1610: INTO l_person_type_id
1611: FROM per_person_types
1612: WHERE business_group_id = l_business_group_id --Bug fix 3648477
1613: AND system_person_type = 'OTHER'
1614: AND default_flag = 'Y';
1615: --