DBA Data[Home] [Help]

APPS.PER_DB_PER_ADDITIONAL dependencies on PER_BUSINESS_GROUPS

Line 892: FROM per_business_groups

888: SELECT business_group_id
889: , people_group_structure
890: INTO l_business_group_id
891: , l_people_group_structure
892: FROM per_business_groups
893: WHERE name = p_business_group;
894: --
895: hr_utility.set_location('per_db_per_additional.create_applicant',2);
896: --

Line 1289: FROM per_business_groups

1285: , cost_allocation_structure
1286: INTO l_business_group_id
1287: , l_people_group_structure
1288: , l_cost_allocation_structure
1289: FROM per_business_groups
1290: WHERE name = p_business_group;
1291: --
1292: hr_utility.set_location('per_db_per_additional.create_employee',2);
1293: --

Line 1604: FROM per_business_groups

1600: hr_utility.set_location('per_db_per_additional.create_other',1);
1601: --
1602: SELECT business_group_id
1603: INTO l_business_group_id
1604: FROM per_business_groups
1605: WHERE name = p_business_group;
1606: --
1607: hr_utility.set_location('per_db_per_additional.create_other',2);
1608: --

Line 1736: FROM per_business_groups

1732: , people_group_structure
1733: INTO l_business_group_id
1734: , l_cost_allocation_structure
1735: , l_people_group_structure
1736: FROM per_business_groups
1737: WHERE name = p_business_group;
1738: --
1739: hr_utility.set_location('per_db_per_additional.create_secondary_assign',2);
1740: l_effective_start_date := nvl(p_effective_start_date,trunc(SYSDATE));

Line 2213: FROM per_business_groups

2209: --
2210: hr_utility.set_location('per_db_per_additional.create_contact',1);
2211: SELECT business_group_id
2212: INTO l_business_group_id
2213: FROM per_business_groups
2214: WHERE name = p_business_group;
2215: --
2216: l_effective_start_date := nvl(p_effective_start_date,trunc(SYSDATE));
2217: l_effective_end_date := nvl(p_effective_end_date,