DBA Data[Home] [Help]

APPS.PAY_US_DB_PER_SETUP dependencies on PER_BUSINESS_GROUPS

Line 559: FROM per_business_groups

555: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
556: --
557: SELECT business_group_id
558: INTO l_business_group_id
559: FROM per_business_groups
560: WHERE name = p_business_group;
561: --
562: l_organization_id := insert_organization_unit('N'
563: ,p_name

Line 672: FROM per_business_groups

668: hr_utility.set_location('pay_us_db_per_setup.create_per_organization',1);
669: --
670: SELECT business_group_id
671: INTO l_business_group_id
672: FROM per_business_groups
673: WHERE name = p_business_group;
674: --
675: l_organization_id := insert_organization_unit('N'
676: ,p_name

Line 1601: FROM per_business_groups

1597: SELECT business_group_id
1598: , job_structure
1599: INTO l_business_group_id
1600: , l_structure_num
1601: FROM per_business_groups
1602: WHERE name = p_business_group
1603: AND business_group_id + 0 <> 0;
1604: --
1605: --

Line 1898: FROM per_business_groups

1894: SELECT business_group_id
1895: , position_structure
1896: INTO l_business_group_id
1897: , l_structure_num
1898: FROM per_business_groups
1899: WHERE name = p_business_group
1900: AND business_group_id + 0 <> 0;
1901: --
1902: hr_utility.set_location('pay_us_db_per_setup.create_position',2);

Line 2198: FROM per_business_groups

2194: SELECT business_group_id
2195: , grade_structure
2196: INTO l_business_group_id
2197: , l_structure_num
2198: FROM per_business_groups
2199: WHERE name = p_business_group
2200: AND business_group_id + 0 <> 0;
2201: --
2202: --

Line 2410: FROM per_business_groups

2406: hr_utility.set_location('scltstdat.create_wc_carrier',1);
2407: --
2408: SELECT business_group_id
2409: INTO l_business_group_id
2410: FROM per_business_groups
2411: WHERE name = p_business_group;
2412: --
2413: l_wc_carrier_id := pay_us_db_per_setup.insert_organization_unit
2414: ('N'