DBA Data[Home] [Help]

APPS.CSP_PARTS_REPAIR dependencies on HR_ORGANIZATION_UNITS

Line 73: from hr_organization_units

69: -- get ship to of repair organization
70: begin
71: select location_id
72: into l_order_hdr_Rec.ship_to_location_id
73: from hr_organization_units
74: where organization_id = p_repair_supplier_id;
75: exception
76: when no_data_found then
77: null;

Line 117: from hr_organization_units

113: -- get ship to of FS organization
114: begin
115: select location_id
116: into l_order_hdr_Rec.ship_to_location_id
117: from hr_organization_units
118: where organization_id = px_header_rec.dest_organization_id;
119: exception
120: when no_data_found then
121: null;