DBA Data[Home] [Help]

APPS.PA_CC_TRANSFER_PRICE dependencies on HR_OPERATING_UNITS

Line 2123: -- in hr_operating_units

2119:
2120: IF l_legal_entity IS NOT NULL THEN
2121: x_legal_entity_id := to_number(l_legal_entity);
2122: -- conversion required as legal_entity_id is stored as varchar2
2123: -- in hr_operating_units
2124: END IF;
2125:
2126: pa_debug.Reset_err_stack;
2127:

Line 2177: from hr_operating_units

2173:
2174: Cursor c_business_group
2175: is
2176: select business_group_id
2177: from hr_operating_units
2178: where organization_id = p_org_id;
2179:
2180: l_business_group hr_operating_units.business_group_id%TYPE;
2181:

Line 2180: l_business_group hr_operating_units.business_group_id%TYPE;

2176: select business_group_id
2177: from hr_operating_units
2178: where organization_id = p_org_id;
2179:
2180: l_business_group hr_operating_units.business_group_id%TYPE;
2181:
2182: BEGIN
2183: pa_debug.Set_err_stack ('Get_Business_group');
2184: pa_debug.G_Err_Stage := 'Get bisiness_group of Org'||to_char(p_org_id);