DBA Data[Home] [Help]

APPS.CSP_PLANNED_ORDERS dependencies on HR_ORGANIZATION_INFORMATION

Line 162: from hr_organization_information

158: l_repair_supplier_id IS NOT NULL) Then
159:
160: Select count(*)
161: into l_supplier_count
162: from hr_organization_information
163: where ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
164: and org_information3 = l_repair_supplier_id
165: and organization_id = l_repair_organization_id;
166:

Line 241: from hr_organization_information

237: ELSE
238: begin
239: Select organization_id
240: into l_repair_supplier_org_id
241: from hr_organization_information
242: where ORG_INFORMATION_CONTEXT = 'Customer/Supplier Association'
243: and org_information3 = l_repair_supplier_id;
244:
245: Begin