APPS.PAY_US_DB_PER_SETUP dependencies on HR_ALL_ORGANIZATION_UNITS

Line 86: 110.3 19-JAN-99 nbristow insert into hr_all_organization_units rather

82: CREATE_WC_CARRIER and CREATE_US_LOCATION.
83: 40.9 01-NOV-95 JTHURING Removed error checking from end of script
84: 110.2 11-SEP-97 khabibul added suffix _vl to fnd_id_flex_structures as
85: id_flex_structure_name col is obsolete.
86: 110.3 19-JAN-99 nbristow insert into hr_all_organization_units rather
87: than hr_organization_units.
88: 115.2 24-MAR-99 sdoshi Flexible Dates Conversion.
89: 115.3 24-MAR-99 alogue MLS changes.
90: 115.4 14-May-1999 mmillmor multi radix change to working_hours on position

Line 140: INSERT INTO HR_ALL_ORGANIZATION_UNITS

136: --
137: --
138: hr_utility.set_location('pay_us_db_per_setup.insert_organization_unit',2);
139: --
140: INSERT INTO HR_ALL_ORGANIZATION_UNITS
141: (organization_id
142: ,business_group_id
143: ,cost_allocation_keyflex_id
144: ,location_id

Line 185: INSERT INTO HR_ALL_ORGANIZATION_UNITS_TL

181: FETCH get_languages
182: INTO language;
183: EXIT WHEN get_languages%NOTFOUND;
184: --
185: INSERT INTO HR_ALL_ORGANIZATION_UNITS_TL
186: (organization_id
187: ,language
188: ,source_lang
189: ,name

Line 842: FROM hr_all_organization_units

838: hr_utility.set_location('pay_us_db_per_setup.create_pay_legal_company',1);
839: --
840: SELECT business_group_id
841: INTO l_business_group_id
842: FROM hr_all_organization_units
843: WHERE name = p_business_group
844: and business_group_id + 0 = organization_id;
845: --
846: l_legal_company_id := insert_organization_unit('N'